/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.2.100
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : 192.168.2.100:3306
 Source Schema         : fk_test

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : 65001

 Date: 22/07/2020 11:12:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for es_ask_message
-- ----------------------------
DROP TABLE IF EXISTS `es_ask_message`;
CREATE TABLE `es_ask_message` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `goods_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
  `goods_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品图片',
  `ask_id` bigint(20) DEFAULT NULL COMMENT '会员咨询id',
  `ask` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '咨询内容',
  `ask_member` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '咨询会员',
  `reply_id` bigint(20) DEFAULT NULL COMMENT '会员回复咨询id',
  `reply` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回复内容',
  `reply_member` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回复会员',
  `send_time` bigint(20) DEFAULT NULL COMMENT '消息发送时间',
  `is_del` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除状态 DELETED：已删除 NORMAL：正常',
  `is_read` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '是否已读 YES：是 NO：否',
  `receive_time` bigint(20) DEFAULT NULL COMMENT '消息接收时间',
  `msg_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '咨询消息类型 ASK：提问消息 REPLY：回复消息',
  `ask_anonymous` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '咨询人是否匿名 YES:是，NO:否',
  `reply_anonymous` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回复咨询人是否匿名 YES:是，NO:否',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_ask_message` (`id`,`member_id`,`goods_id`,`ask_id`,`reply_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of es_ask_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_ask_reply
-- ----------------------------
DROP TABLE IF EXISTS `es_ask_reply`;
CREATE TABLE `es_ask_reply` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `ask_id` bigint(20) DEFAULT NULL COMMENT '会员咨询id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员名称',
  `content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回复内容',
  `reply_time` bigint(20) DEFAULT NULL COMMENT '回复时间',
  `anonymous` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '是否匿名 YES:是，NO:否',
  `auth_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审核状态 WAIT_AUDIT:待审核,PASS_AUDIT:审核通过,REFUSE_AUDIT:审核未通过',
  `is_del` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除状态 DELETED：已删除 NORMAL：正常',
  `reply_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '是否已回复 YES:是，NO:否',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ES_INDEX_ASK_ID` (`ask_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of es_ask_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_clerk
-- ----------------------------
DROP TABLE IF EXISTS `es_clerk`;
CREATE TABLE `es_clerk` (
  `clerk_id` bigint(20) NOT NULL COMMENT '店员id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `clerk_name` varchar(50) DEFAULT NULL COMMENT '店员名称',
  `founder` int(2) DEFAULT NULL COMMENT '是否为超级管理员，1为超级管理员 0为其他管理员',
  `role_id` bigint(20) DEFAULT NULL COMMENT '权限id',
  `user_state` int(2) DEFAULT NULL COMMENT '店员状态，0为禁用，1为正常',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建日期',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  PRIMARY KEY (`clerk_id`) USING BTREE,
  KEY `index_clerk` (`clerk_id`,`member_id`,`role_id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店员(es_clerk)';

-- ----------------------------
-- Records of es_clerk
-- ----------------------------
BEGIN;
INSERT INTO `es_clerk` VALUES (1, 2, 'javashop', 1, 0, 0, 1533519029, 1);
INSERT INTO `es_clerk` VALUES (2, 6, 'demo_woman', 1, 0, 0, 1533519029, 5);
INSERT INTO `es_clerk` VALUES (3, 11, 'toys', 1, 0, 0, 1533519029, 10);
INSERT INTO `es_clerk` VALUES (4, 16, 'food', 1, 0, 0, 1533519029, 15);
INSERT INTO `es_clerk` VALUES (5, 25, 'superman', 1, 0, 0, 1533519029, 16);
INSERT INTO `es_clerk` VALUES (6, 26, 'kans', 1, 0, 0, 1533519029, 17);
INSERT INTO `es_clerk` VALUES (7, 27, 'appliance', 1, 0, 0, 1533519029, 18);
INSERT INTO `es_clerk` VALUES ('1470960404935438338', '1470959847998828545', 'ceshi', '1', '0', '0', '1639539264', '1470960016404328449');
COMMIT;

-- ----------------------------
-- Table structure for es_comment_gallery
-- ----------------------------
DROP TABLE IF EXISTS `es_comment_gallery`;
CREATE TABLE `es_comment_gallery` (
  `img_id` bigint(20) NOT NULL COMMENT '主键',
  `comment_id` bigint(20) DEFAULT NULL COMMENT '主键',
  `original` varchar(255) DEFAULT NULL COMMENT '图片路径',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`img_id`) USING BTREE,
  KEY `index_comment_gallery` (`img_id`,`comment_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='评论图片(es_comment_gallery)';

-- ----------------------------
-- Records of es_comment_gallery
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_comment_reply
-- ----------------------------
DROP TABLE IF EXISTS `es_comment_reply`;
CREATE TABLE `es_comment_reply` (
  `reply_id` bigint(20) NOT NULL COMMENT '主键',
  `comment_id` bigint(20) DEFAULT NULL COMMENT '评论id',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '回复父id',
  `content` longtext COMMENT '回复内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `role` varchar(50) DEFAULT NULL COMMENT '商家或者买家',
  `path` varchar(100) DEFAULT NULL COMMENT '父子路径0|10|',
  `reply_type` varchar(100) DEFAULT NULL COMMENT 'INITIAL',
  PRIMARY KEY (`reply_id`) USING BTREE,
  KEY `index_comment_reply` (`reply_id`,`comment_id`,`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='评论回复(es_comment_reply)';

-- ----------------------------
-- Records of es_comment_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_connect
-- ----------------------------
DROP TABLE IF EXISTS `es_connect`;
CREATE TABLE `es_connect` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `union_id` varchar(50) DEFAULT NULL COMMENT '第三方唯一标示',
  `union_type` varchar(50) DEFAULT NULL COMMENT '信任登录类型',
  `unbound_time` bigint(50) DEFAULT NULL COMMENT '解绑时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_connect` (`id`,`member_id`,`union_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='信任登录(es_connect)';

-- ----------------------------
-- Records of es_connect
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_connect_setting
-- ----------------------------
DROP TABLE IF EXISTS `es_connect_setting`;
CREATE TABLE `es_connect_setting` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `type` varchar(50) DEFAULT NULL COMMENT '授权类型',
  `config` longtext COMMENT '参数组',
  `name` varchar(50) DEFAULT NULL COMMENT '标题',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_connect_setting` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='信任登录参数(es_connect_setting)';

-- ----------------------------
-- Records of es_connect_setting
-- ----------------------------
BEGIN;
INSERT INTO `es_connect_setting` VALUES (15, 'QQ', '[{\"name\":\"网页端参数 （PC，WAP，微信网页端）\",\"configList\":[{\"key\":\"qq_pc_app_id\",\"name\":\"AppId\",\"value\":\"输入qq网页信任登录 AppID\"},{\"key\":\"qq_pc_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq网页信任登录 AppKey\"}]},{\"name\":\"原生-APP参数(安卓)\",\"configList\":[{\"key\":\"qq_native_android_app_id\",\"name\":\"AppId\",\"value\":\"输入qq 原生-APP参数(安卓) AppID\"},{\"key\":\"qq_native_android_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq 原生-APP参数(安卓) AppKey\"}]},{\"name\":\"原生-APP参数(IOS)\",\"configList\":[{\"key\":\"qq_native_ios_app_id\",\"name\":\"AppId\",\"value\":\"输入qq 原生-APP参数(IOS) AppId\"},{\"key\":\"qq_native_ios_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq 原生-APP参数(IOS) AppKey\"}]},{\"name\":\"RN-APP参数(安卓)\",\"configList\":[{\"key\":\"qq_rn_android_app_id\",\"name\":\"AppId\",\"value\":\"输入qq RN-APP参数(安卓) AppId\"},{\"key\":\"qq_rn_android_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq RN-APP参数(安卓) AppKey\"}]},{\"name\":\"RN-APP参数(IOS)\",\"configList\":[{\"key\":\"qq_rn_ios_app_id\",\"name\":\"AppId\",\"value\":\"输入qq RN-APP参数(IOS) AppId\"},{\"key\":\"qq_rn_ios_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq RN-APP参数(IOS) AppKey\"}]}]', 'QQ信任登录参数配置');
INSERT INTO `es_connect_setting` VALUES (16, 'WEIBO', '[{\"name\":\"网页端参数 （PC，WAP，微信网页端）\",\"configList\":[{\"key\":\"weibo_pc_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_pc_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]},{\"name\":\"原生-APP参数\",\"configList\":[{\"key\":\"weibo_app_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_app_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]},{\"name\":\"RN-APP参数\",\"configList\":[{\"key\":\"weibo_rn_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_rn_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]}]', '微博信任登录参数配置');
INSERT INTO `es_connect_setting` VALUES (17, 'WECHAT', '[{\"name\":\"PC网页端参数\",\"configList\":[{\"key\":\"wechat_pc_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信PC登录app_id\"},{\"key\":\"wechat_pc_app_key\",\"name\":\"app_secret\",\"value\":\"请输入微信PC登录app_secret\"}]},{\"name\":\"微信网页端参数\",\"configList\":[{\"key\":\"wechat_wechat_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信网页端登录app_id\"},{\"key\":\"wechat_wechat_app_key\",\"name\":\"app_secret\",\"value\":\"请输入微信网页端登录app_secret\"}]},{\"name\":\"原生-APP参数\",\"configList\":[{\"key\":\"wechat_app_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信原生-APP登录app_id\"},{\"key\":\"wechat_app_app_key\",\"name\":\"app_secret\",\"value\":\"请输入微信原生-APP登录app_secret\"}]},{\"name\":\"RN-APP参数\",\"configList\":[{\"key\":\"wechat_rn_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信RN-APP登录app_id\"},{\"key\":\"wechat_rn_app_key\",\"name\":\"app_secret\",\"value\":\"请输入微信RN-APP登录app_secret\"}]},{\"name\":\"小程序参数\",\"configList\":[{\"key\":\"wechat_miniprogram_app_id\",\"name\":\"app_id\",\"value\":\"请输入小程序登录app_id\"},{\"key\":\"wechat_miniprogram_app_key\",\"name\":\"app_secret\",\"value\":\"请输入小程序登录app_secret\"}]}]', '微信参数配置');
INSERT INTO `es_connect_setting` VALUES (18, 'ALIPAY', '[{\"name\":\"PC端参数\",\"configList\":[{\"key\":\"alipay_pc_app_id\",\"name\":\"app_id\",\"value\":\"输入支付宝 app_id\"},{\"key\":\"alipay_pc_private_key\",\"name\":\"商户私钥\",\"value\":\"输入商户 私钥\"},{\"key\":\"alipay_pc_public_key\",\"name\":\"支付宝公钥\",\"value\":\"输入支付宝 公钥\"}]},{\"name\":\"WAP端参数\",\"configList\":[{\"key\":\"alipay_wap_app_id\",\"name\":\"app_id\",\"value\":\"输入支付宝 app_id\"},{\"key\":\"alipay_wap_private_key\",\"name\":\"商户私钥\",\"value\":\"输入商户 私钥\"},{\"key\":\"alipay_wap_public_key\",\"name\":\"支付宝公钥\",\"value\":\"输入支付宝 公钥\"}]},{\"name\":\"app端参数\",\"configList\":[{\"key\":\"alipay_app_app_id\",\"name\":\"app_id\",\"value\":\"输入支付宝 app_id\"},{\"key\":\"alipay_app_private_key\",\"name\":\"商户私钥\",\"value\":\"输入商户 私钥\"},{\"key\":\"alipay_app_public_key\",\"name\":\"支付宝公钥\",\"value\":\"输入支付宝 公钥\"}]}]', '支付宝参数配置');
COMMIT;

-- ----------------------------
-- Table structure for es_history
-- ----------------------------
DROP TABLE IF EXISTS `es_history`;
CREATE TABLE `es_history` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `goods_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
  `goods_price` decimal(20,2) DEFAULT NULL COMMENT '商品价格',
  `goods_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品主图',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员名称',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间，按天存',
  `update_time` bigint(20) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_history` (`id`,`goods_id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of es_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member
-- ----------------------------
DROP TABLE IF EXISTS `es_member`;
CREATE TABLE `es_member` (
  `member_id` bigint(20) NOT NULL COMMENT '会员ID',
  `uname` varchar(255) DEFAULT NULL COMMENT '会员登陆用户名',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `password` varchar(255) DEFAULT NULL COMMENT '会员登陆密码',
  `create_time` bigint(20) DEFAULT NULL COMMENT '会员注册时间',
  `sex` int(1) DEFAULT NULL COMMENT '会员性别 1：男，0：女',
  `birthday` bigint(20) DEFAULT NULL COMMENT '会员生日',
  `province_id` bigint(20) DEFAULT NULL COMMENT '所属省份ID',
  `city_id` bigint(20) DEFAULT NULL COMMENT '所属城市ID',
  `county_id` bigint(20) DEFAULT NULL COMMENT '所属县(区)ID',
  `town_id` bigint(20) DEFAULT NULL COMMENT '所属城镇ID',
  `province` varchar(255) DEFAULT NULL COMMENT '所属省份名称',
  `city` varchar(255) DEFAULT NULL COMMENT '所属城市名称',
  `county` varchar(255) DEFAULT NULL COMMENT '所属县(区)名称',
  `town` varchar(255) DEFAULT NULL COMMENT '所属城镇名称',
  `address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `tel` varchar(255) DEFAULT NULL COMMENT '座机号码',
  `grade_point` bigint(20) DEFAULT NULL COMMENT '等级积分',
  `msn` varchar(255) DEFAULT NULL COMMENT '会员MSN',
  `remark` varchar(255) DEFAULT NULL COMMENT '会员备注',
  `last_login` bigint(20) DEFAULT NULL COMMENT '上次登陆时间',
  `login_count` int(10) DEFAULT NULL COMMENT '登陆次数',
  `is_cheked` int(1) DEFAULT NULL COMMENT '邮件是否已验证',
  `register_ip` varchar(255) DEFAULT NULL COMMENT '注册IP地址',
  `recommend_point_state` int(10) DEFAULT NULL COMMENT '是否已经完成了推荐积分',
  `info_full` int(1) DEFAULT NULL COMMENT '会员信息是否完善',
  `find_code` varchar(255) DEFAULT NULL COMMENT 'find_code',
  `face` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `midentity` varchar(255) DEFAULT NULL COMMENT '身份证号',
  `disabled` int(8) DEFAULT NULL COMMENT '会员状态',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺ID',
  `have_shop` int(1) DEFAULT NULL COMMENT '是否开通店铺',
  `consum_point` bigint(20) DEFAULT NULL COMMENT '消费积分',
  `nickname` varchar(255) DEFAULT NULL COMMENT '昵称',
  `sign` varchar(255) DEFAULT NULL,
  `sign_result` int(1) DEFAULT '0',
  `scan_rounds` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT '1' COMMENT '用户状态:1:正常;0:休眠;',
  PRIMARY KEY (`member_id`) USING BTREE,
  KEY `ind_member_uname` (`uname`) USING BTREE,
  KEY `ind_member_b2b2c` (`shop_id`,`have_shop`) USING BTREE,
  KEY `ind_member_mobile` (`mobile`) USING BTREE,
  KEY `ind_member_email` (`email`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员表(es_member)';

-- ----------------------------
-- Records of es_member
-- ----------------------------
INSERT INTO `es_member` VALUES ('2', 'javashop', '2459931371@qq.com', '94757b9164d28f1611abb019e476726b', '1421329021', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'U9V9/sNmK47haq4dVIYh1w==', null, '84', null, null, '1536046991', '1', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/55D38B934E6F4E13AE0C906807173295.JPG', null, '0', '1', '1', '84', 'javashop', '44f34c9cb5559b6be0abe91224e98c9b', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('6', 'demo_woman', 'demo_woman@Javashop.com', '5d6bfc690b4e5aa1f6a6eeb3ba06005f', '1427854864', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'V6sIeKIgiGDdMYAouZ1qfg==', null, '157', null, null, '1544063195', '1', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/206F856561ED4A9EB5CEBD0A4E2E8E29.GIF', null, '0', '5', '1', '157', 'demo_woman', '3d547b924ce9ba4111fb4be624a32efa', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('11', 'toys', 'toys@Javashop.com', 'dd36834705f598cc078f6865def7f0cf', '1427962143', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'xy32jJ00qxo8oo8vPyZQqQ==', null, '102', null, null, '1544063237', '1', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5A0A170E22814619B5364CB38305F52E.GIF', null, '0', '10', '1', '102', 'toys', '1f6fea26965ad7bffc5a89822656726c', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('16', 'food', 'food@Javashop.com', 'db383ded6a3f1efe1b9e9be146bdeae0', '1428651298', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'PDeiKP1e1DSrMtfsan51WA==', null, '25338', null, null, '1639721531', '20', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/B79BBB3E76BD49508998F30A211E01EC.png', null, '0', '15', '1', '25338', 'asasdsadasd', 'aa91efa27215762db4e16d85ef97a83c', '1', '202117', '1');
INSERT INTO `es_member` VALUES ('25', 'superman', 'superman@Javashop.com', '34f0e4bd96fbdbdd73a0fc1a53029988', '1464430868', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'UMkh+hcheRzljCrs3wWQtw==', null, '70', null, null, '1544063337', '1', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F048B8CD2A68472CAC5EACE151B2EDCC.GIF', null, '0', '16', '1', '70', 'superman', '0406a130b2da055607bfa44f53b39e56', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('26', 'kans', 'kansa@Javashop.com', 'cc5f295e4c8b28b5ff6d0a378005fe2f', '1464509078', '0', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'XqJW988hJ9DrIPk/QhWEiA==', null, '124', null, null, '1639730234', '29', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/normal/8F14D2C439004507AA3B8B4D00AD2A6C.png', null, '0', '17', '1', '124', 'kans', '6c337263aed13a6df53c89c1f036e7f3', '1', '202117', '1');
INSERT INTO `es_member` VALUES ('27', 'appliance', 'appliance@Javashop.com', '683b618f110bd6450499f7ae6f80a252', '1508506621', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '地址', 'd1LccW2ViR6rXYu4/IfaTA==', null, '135328', null, null, '1544063398', '1', '1', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', null, '0', '18', '1', '135328', 'appliance', 'a5b30d3bba1957fa1fffe30b7da75bad', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('28', 'kanon', '11111154@qq.com', '24ed91416e9450ed3fb14b10d6a71ef3', '1509000654', '1', '1508342400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '你猜', 'lKzRuK/5RxA7VY7KWVK8EA==', null, '128142', null, null, '1544063468', '1', '1', '192.168.2.139', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/AA8B286B84F24B458EA3F67C71D8E2BD.jpg', null, '0', null, '0', '128142', 'kanon', '97e547c8e7f8f462f1d5bcb63190758b', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('29', 'wanghui', '225451212@qq.com', '3172d35318e8ffcb95b50d7fb89d9721', '1509000745', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '01Fymigk7bkcKktYbGQpZw==', null, '419', null, null, '1509011450', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '419', 'wanghui', '2baa3ce4f1c89d95339b46f799c3218a', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('30', 'xulipeng', '334551122@qq.com', 'c8ed9d8201d3f9cdbf2b3c79018c4019', '1509000772', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'uyykDoV3faJgUAR62dSG1Q==', null, '50', null, null, '1509000772', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '50', 'xulipeng', '3d54705ded7bade3e34b13b1e03bf5ef', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('31', 'spring', '99451212@qq.com', 'a6852255248e7f2e5e493d001c0e4806', '1509009430', '0', '1508342400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '哼', 'nvuFM5v0Lz/XqXU/LMFLZw==', null, '63965', null, null, '1509356340', '0', '1', '192.168.2.139', '0', '0', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/A3EFA87D429F4BC48E7F010D59C546AE.jpg', null, '0', null, '0', '63965', 'spring', 'd0493ca11ca293240feb08b2ba4ef287', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('32', 'martin', '10032525@qq.ccom', '093614ebaa32605e9414c88db13f0bfa', '1509009465', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'LR1B6/8VbVTJJadN2ISKjg==', null, '0', null, null, '1509009465', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '0', 'martin', '0f0374c476e2b0e6b8fe4b60c7e06733', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('33', 'java', '12345678@qq.com', '3085eb2c776bfde4806971be381e265f', '1509009516', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'b28Em7RCvoSJUo0vkTp6qg==', null, '50', null, null, '1509009517', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '50', 'java', '0d4a076fa742a540dd99a471d70268ab', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('34', '六月的雨', '90902225@qq.com', 'ea194b87d9fef34b40a635d33b3e58e8', '1509009562', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '1tF3bRRl3+DVRW19KWZfIA==', null, '5', null, null, '1509088232', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '5', '六月的雨', '46d77150dd67f3d8a7cc306940a49d81', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('35', '陈冠希_', '989855541@qq.com', '319ba810ca4304285a464b4301ff96cd', '1509009674', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'GDO1tNMnV/FOFi3EQ4uwiQ==', null, '3162', null, null, '1509085511', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '3162', '陈冠希_', 'c14c00c05256ccebe08a80a49e8bdf9b', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('36', '秋刀鱼的滋味', '88884512@qq.com', 'dad54e45a6db3d8015361d58aa78c37a', '1509009737', '0', '1508256000', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '0.0', 'jRJt+ctqXp6WkeeLxAjgmQ==', null, '49693', null, null, '1509356392', '0', '1', '192.168.2.139', '0', '0', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/619A016E4C29439290CC95AE3ED07102.jpg', null, '0', null, '0', '49693', '秋刀鱼的滋味', '0009c3cb2a33192b860732d5ad345126', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('37', '春风十里_不如你', '827254252@qq.com', '6db347f89f541258a745897f7c747a70', '1509009786', '0', '1508256000', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '地址', 'fb6q0OxvD8wNiSC/Nijwcw==', null, '78351', null, null, '1509352996', '0', '1', '192.168.2.139', '0', '0', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/CBFBB8EBCC324ED3A69BF0F2B0D7B50E.jpeg', null, '0', null, '0', '78351', '春风十里_不如你', '5d8f246c931857786610fb8cad779ffb', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('38', '下个路口见', '77455112@qq.com', 'a6f3301422704a3f7650eb4e2aae363c', '1509009923', '0', '1507046400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '村里', 'UGSgXtNVsjolO5Em9+IwkQ==', null, '78954', null, null, '1509009923', '0', '1', '192.168.2.139', '0', '0', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/AD3F672CDF5C4010A5008CFDBAA07A88.jpg', null, '0', null, '0', '78954', '下个路口见', 'c96813013a24dcf65727c03082a9777e', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('39', 'batman', '15143165@qq.com', '8fdc6afab454dadaf1893b4864592473', '1509073225', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'NUmO94OL7ZIpHEuCM/WsOQ==', null, '20066', null, null, '1509091992', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '20066', 'batman', '16174839af7d07d48e439edcbdb391ff', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('40', 'spiderman', '84451151@qq.com', '97175d61bc468feda5d625ce32972b84', '1509073858', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'NIG5Hh6D11uzExJxnrbJlw==', null, '2548', null, null, '1509093008', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '2548', 'spiderman', '5c7d00771b0c48cb6af7e5e175cfe597', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('41', 'antman', '879641313@qq.com', 'df35354570a98bb805d8bfefa3fe0b7c', '1509074080', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'fMfBoT6pLGFD28RURlZJtQ==', null, '3209', null, null, '1509094606', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '3209', 'antman', '623ccb0bbddf8ffa1e7e59c2e886a979', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('42', 'ironman', '87564131@qq.com', '1e097151cb09cc5d67f205445271e192', '1509074212', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'pOHZtVBBul9t99iwWKhRmA==', null, '41664', null, null, '1509094035', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '41664', 'ironman', 'a0b21d99bf0cb64a4a9919d1d70088cb', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('43', 'hock', '45441564@qq.com', '42ace5e316d1b3268c5a6b9e79383dd8', '1509074489', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'RYCMQG3EZpZqIAIq+FQpoA==', null, '1488', null, null, '1509089167', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '1488', 'hock', 'f278339e639fe8f2107a01324eff2d43', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('44', 'eagle', '13894561@qq.com', 'b83081bb5ac21aa73c52d647181ea7e2', '1509075137', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'o1EEVm/MFddbYk4LWC7Vwg==', null, '10937', null, null, '1509089276', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '10937', 'eagle', '502f16392955b9e8e85d020ce84a8600', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('45', 'green', '154684615@qq.com', '242c9ca785be114e7cbc8ae8cfc9d505', '1509075866', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '1PA6pZ1zWwAQPm0u7j0cUA==', null, '1011', null, null, '1545734441', '4', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '1011', 'green', 'd82846b43bcd4c2043df3038d02c085b', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('46', 'blue', '874565615@qq.com', '0e8c609c1b59a6161fe0495388fa4414', '1509084831', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'w3MxyAFaSGMDfyd090o1mQ==', null, '34727', null, null, '1535447809', '3', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '34727', 'blue', '252d3c8f74593ac4b8f343a966d3bcf0', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('47', 'black', '78964131@qq.com', '80764252de556de1b0533a4496139b38', '1509084961', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'kXDG9/HLJWNHoR4jr1CbxQ==', null, '3260', null, null, '1535438520', '1', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '3260', 'black', 'c682993b9ca60571417c4c6a1a2efd09', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('48', 'lion', '46546131@qq.com', '2026bd7d5ab6dfd6446529793f5b24d7', '1509085091', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'ES35M7AhZvu0KrSsiltZBg==', null, '3789', null, null, '1509089619', '0', '1', '192.168.2.230', '0', '0', null, '', null, '0', null, '0', '3789', 'lion', 'f3d947d3a2e5decad8130a608d173b3a', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('49', '麦芽糖_', 'lfl@javashop.cn', 'd7db785b1da8bed71f47f4f29d282087', '1509431392', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'xBGMqgBT14AO+S1+QXC9Jg==', null, '15775', null, null, '1509431392', '0', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '15775', '麦芽糖_', '9fdb4d56701a7c49327c2a6b4220321a', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('50', '回到过去', 'xlp@javashop.cn', '7d34770825938b7a84418ca01f1286ec', '1509433744', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'hLwUXP6YnusY6WLUiYx0Dg==', null, '81355', null, null, '1534847138', '1', '1', '192.168.2.139', '0', '0', null, '', null, '0', null, '0', '79855', '回到过去', '44dc521781611b35bc2ca8d5f2d2166a', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('51', 'm_18555555555', '46464313@qq.com', '1a19ddb1c95057279cdf1842b9cc08d3', '1534837036', '1', '1534780800', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'b5yDeLxS+Bya8Aipxt6Ysg==', null, '2196', null, null, '1535075722', '22', '1', '192.168.2.105', '0', '1', null, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/normal/BF491C3A06B746718BBDC4E79633A529.png', null, '0', null, '0', '2196', 'Andste', '5cd8984a4e91d17bd56135fe1c92a1d2', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('52', 'fengkun', '44521255@qq.com', '0e9b5f071f62520685bed9d640d658b6', '1534917930', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'POPQIeXY4stmB72NpRDtmA==', null, '2', null, null, '1535100978', '3', '1', '192.168.2.5', '0', '0', null, '', null, '0', null, '0', '2', 'fengkun', '2752da1df199599e0dd47c856cc7f9d9', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('53', 'chopper', '545464633@qq.com', '762f74f150721bb0ab20ec89bd1ed477', '1535340715', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'R4pHD1Ig2DlzoJ6DBXM4FA==', null, '3', null, null, '1535340715', '1', '1', '192.168.2.5', '0', '0', null, '', null, '0', null, '0', '3', 'chopper', '6e061590fc33a700426bebc6960c9bd6', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('54', 'AAA', '784321653@qq.com', '228f5802bc107ec13f797fbaf536bb55', '1535442162', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, 'abQrkioOLSXNKkKjn8XoNg==', null, '1', null, null, '1535442163', '1', '1', '192.168.2.105', '0', '0', null, '', null, '0', null, '0', '1', 'AAA', '69c744899fecd1413baded4453f0798d', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('55', 'javashop7', '879866465@qq.com', '111777d501c44e2a12e6eae0bdfab636', '1535443163', '1', '684383369', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '6wGIhUZTUs9sWSOKkAZYXw==', null, '2', null, null, '1535507093', '6', '1', '192.168.2.5', '0', '0', null, '', null, '0', null, '0', '2', 'javashop7', '54393dc9c0e168913d4d9c70e19069b0', '1', '202117', '0');
INSERT INTO `es_member` VALUES ('1470959847998828545', 'ceshi', null, '394332d105f054d3bd57f54226c4ce92', '1639539131', '1', null, null, null, null, null, null, null, null, null, null, 'loHd0UTQFPLf7KCeGuY+2A==', null, '1', null, null, '1639539131', '1', null, '192.168.2.220', null, '0', null, null, null, '0', '1470960016404328449', '1', '1', 'ceshi', '24ca4f754d4eeb6741f969258b7b677e', '1', '202117', '0');

-- ----------------------------
-- Table structure for es_member_address
-- ----------------------------
DROP TABLE IF EXISTS `es_member_address`;
CREATE TABLE `es_member_address` (
  `addr_id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
  `country` varchar(255) DEFAULT NULL COMMENT '收货人国籍',
  `province_id` bigint(20) DEFAULT NULL COMMENT '所属省份ID',
  `city_id` bigint(20) DEFAULT NULL COMMENT '所属城市ID',
  `county_id` bigint(20) DEFAULT NULL COMMENT '所属县(区)ID',
  `town_id` bigint(20) DEFAULT NULL COMMENT '所属城镇ID',
  `county` varchar(255) DEFAULT NULL COMMENT '所属县(区)名称',
  `city` varchar(255) DEFAULT NULL COMMENT '所属城市名称',
  `province` varchar(255) DEFAULT NULL COMMENT '所属省份名称',
  `town` varchar(255) DEFAULT NULL COMMENT '所属城镇名称',
  `addr` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `tel` varchar(255) DEFAULT NULL COMMENT '联系电话(一般指座机)',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `def_addr` int(1) DEFAULT NULL COMMENT '是否为默认收货地址',
  `ship_address_name` varchar(255) DEFAULT NULL COMMENT '地址别名',
  PRIMARY KEY (`addr_id`) USING BTREE,
  KEY `ind_mem_addr` (`member_id`,`def_addr`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员收货地址表(es_member_address)';

-- ----------------------------
-- Records of es_member_address
-- ----------------------------
BEGIN;
INSERT INTO `es_member_address` VALUES (1, 27, '王峰', NULL, 5, 274, 49707, 49973, '三河市', '廊坊市', '河北', '燕郊镇', '维多利亚大厦D座23A07', '', '18618487753', 0, '公司');
INSERT INTO `es_member_address` VALUES (2, 38, '秋刀鱼', NULL, 10, 712, 714, 33435, '昂昂溪区', '齐齐哈尔市', '黑龙江', '榆树屯镇', '我是地址', NULL, '13333333333', 1, '');
INSERT INTO `es_member_address` VALUES (3, 28, '李奋龙', NULL, 5, 274, 49707, 49973, '三河市', '廊坊市', '河北', '燕郊镇', '上上城五期楼层自己找', NULL, '17045678911', 1, '家里');
INSERT INTO `es_member_address` VALUES (4, 29, '李奋龙', NULL, 5, 274, 49707, 49973, '三河市', '廊坊市', '河北', '燕郊镇', '上上城五期随便送一家', NULL, '17067891234', 1, '家里');
INSERT INTO `es_member_address` VALUES (5, 39, 'asdf', NULL, 3, 51037, 2987, NULL, '全境', '河北区', '天津', '', 'adfdsf', NULL, '13332225555', 1, '家里');
INSERT INTO `es_member_address` VALUES (6, 40, 'kghkjgk', NULL, 24, 2150, 2152, 8641, '六枝特区', '六盘水市', '贵州', '岩脚镇', 'tryutyuyu', NULL, '13336665558', 1, '公司');
INSERT INTO `es_member_address` VALUES (7, 41, 'vbxbdfg', NULL, 2, 2813, 51976, NULL, '城区', '徐汇区', '上海', '', 'sdfdghbvnghj', NULL, '15554445554', 1, '公司');
INSERT INTO `es_member_address` VALUES (8, 42, 'ironman', NULL, 26, 3144, 3960, 12106, '岗巴县', '日喀则地区', '西藏', '昌龙乡', 'dsfasdf', NULL, '18899988899', 1, '家里');
INSERT INTO `es_member_address` VALUES (9, 43, 'hock', NULL, 14, 1201, 1203, 18766, '石台县', '池州市', '安徽', '仁里镇', 'hgjvbnsfdgh', NULL, '13332225552', 1, '学校');
INSERT INTO `es_member_address` VALUES (10, 44, 'ytjumyuj', NULL, 6, 336, 344, 44289, '太谷县', '晋中市', '山西', '北洸乡', 'gm,hjmjh', NULL, '18999999999', 1, '家里');
INSERT INTO `es_member_address` VALUES (11, 45, 'green', NULL, 11, 895, 898, 37877, '突泉县', '兴安盟', '内蒙古', '县城内', 'asdfndsf', NULL, '18999888888', 1, '家里');
INSERT INTO `es_member_address` VALUES (12, 46, 'adsfasdf', NULL, 1, 72, 2799, NULL, '三环以内', '朝阳区', '北京', '', 'sdfsdfgsdf', NULL, '17788899999', 1, '家里');
INSERT INTO `es_member_address` VALUES (13, 47, 'hgjhgj', NULL, 10, 773, 3364, 51255, '桃山区', '七台河市', '黑龙江', '城区', 'dghsdfgsfd', NULL, '18855566666', 1, '家里');
INSERT INTO `es_member_address` VALUES (14, 48, 'asdfsdf', NULL, 18, 1592, 1598, 13704, '凤凰县', '湘西州', '湖南', '落潮井乡', 'asdfsdgasd', NULL, '15566622233', 1, '公司');
INSERT INTO `es_member_address` VALUES (15, 35, '张三', NULL, 6, 309, 311, 32148, '天镇县', '大同市', '山西', '米薪关镇', '小卖部', NULL, '13333333333', 1, '家里');
INSERT INTO `es_member_address` VALUES (16, 34, '张小姐', NULL, 11, 805, 808, 38347, '土默特右旗', '包头市', '内蒙古', '美岱召镇', '小卖部', NULL, '13333333333', 1, '家里');
INSERT INTO `es_member_address` VALUES (17, 31, '二丫', NULL, 2, 2815, 51975, NULL, '城区', '长宁区', '上海', '', '203', NULL, '13333333333', 1, '家里');
INSERT INTO `es_member_address` VALUES (18, 36, '喵小姐', NULL, 6, 336, 339, 44295, '昔阳县', '晋中市', '山西', '乐平镇', '0.0', NULL, '13333333333', 1, '');
INSERT INTO `es_member_address` VALUES (19, 37, '口水', NULL, 2, 2813, 51976, NULL, '城区', '徐汇区', '上海', '', '宿舍楼709', NULL, '13333333333', 1, '学校');
INSERT INTO `es_member_address` VALUES (20, 49, '麦芽糖', NULL, 2, 2813, 51976, NULL, '城区', '徐汇区', '上海', '', '地址', NULL, '13333333333', 1, '');
INSERT INTO `es_member_address` VALUES (21, 50, '张先生', NULL, 2, 2813, 51976, NULL, '城区', '徐汇区', '上海', '', '12312313', NULL, '13333333333', 1, '公司');
INSERT INTO `es_member_address` VALUES (22, 16, '李先生', NULL, 6, 303, 304, 36865, '阳曲县', '太原市', '山西省', '中心镇建设管理办公室', '12312313', NULL, '13333333333', 1, '公司');
INSERT INTO `es_member_address` VALUES (23, 16, '王先生', NULL, 5, 142, 143, 5008, '辛集市', '石家庄市', '河北', '辛集镇', '12312313', NULL, '13333333333', 0, '公司');
INSERT INTO `es_member_address` VALUES (24, 16, '张先生', NULL, 26, 2951, 3123, 21181, '林周县', '拉萨市', '西藏', '边交林乡', '12312313', NULL, '13333333333', 0, '公司');
INSERT INTO `es_member_address` VALUES (27, 2, '测试', '中国', 2, 2813, 51976, 0, '城区', '徐汇区', '上海', '', '测试地址', NULL, '13333333333', 1, '家');
INSERT INTO `es_member_address` VALUES (30, 1, 'AAAAA', '中国', 6, 309, 315, 32163, '浑源县', '大同市', '山西', '蔡村镇', 'asdsadasd', NULL, '15454353455', 1, '');
INSERT INTO `es_member_address` VALUES (31, 52, 'fengkun', '中国', 5, 148, 168, 34054, '峰峰矿区', '邯郸市', '河北', '峰峰镇', 'zscfzxc', NULL, '13636363636', 1, '');
INSERT INTO `es_member_address` VALUES (32, 52, 'zxczxc', '中国', 5, 142, 154, 42817, '栾城县', '石家庄市', '河北', '楼底镇', 'asdas', NULL, '13636363636', 0, '');
INSERT INTO `es_member_address` VALUES (33, 27, '萨达', '中国', 1, 72, 2799, 0, '三环以内', '朝阳区', '北京', '', '萨达撒多撒', NULL, '13636363636', 1, '');
INSERT INTO `es_member_address` VALUES (35, 51, 'AAA', '中国', 5, 274, 49707, 49973, '三河市', '廊坊市', '河北', '燕郊镇', '维多路由A座24层23A07', NULL, '18545454554', 1, '公司');
INSERT INTO `es_member_address` VALUES (36, 51, 'BBB', '中国', 5, 274, 289, 49735, '大厂县', '廊坊市', '河北', '大厂镇', '大厂人家不喜欢详细地址', NULL, '18545456564', 0, '家');
INSERT INTO `es_member_address` VALUES (37, 53, '123', '中国', 1, 72, 2819, 0, '三环到四环之间', '朝阳区', '北京', '', '1312313123133', NULL, '13213121313', 1, '');
INSERT INTO `es_member_address` VALUES (38, 55, '123', '中国', 1, 72, 2799, 0, '三环以内', '朝阳区', '北京', '', '123', NULL, '13212313123', 1, '123');
COMMIT;

-- ----------------------------
-- Table structure for es_member_ask
-- ----------------------------
DROP TABLE IF EXISTS `es_member_ask`;
CREATE TABLE `es_member_ask` (
  `ask_id` bigint(20) NOT NULL COMMENT '主键',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '咨询内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '咨询时间',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '卖家id',
  `reply` longtext COLLATE utf8mb4_unicode_ci COMMENT '卖家回复内容',
  `reply_time` bigint(20) DEFAULT NULL COMMENT '卖家回复时间',
  `reply_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商家回复状态 YES:已回复,NO:未回复',
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除状态 DELETED:已删除,NORMAL:正常',
  `member_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员名称',
  `goods_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
  `member_face` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员头像',
  `auth_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'WAIT_AUDIT' COMMENT '审核状态 WAIT_AUDIT:待审核,PASS_AUDIT:审核通过,REFUSE_AUDIT:审核未通过',
  `goods_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品图片',
  `anonymous` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'NO' COMMENT '是否匿名 YES:是，NO:否',
  `reply_num` int(10) DEFAULT '0' COMMENT '会员问题咨询回复数量',
  PRIMARY KEY (`ask_id`) USING BTREE,
  KEY `index_member_ask` (`ask_id`,`goods_id`,`member_id`,`seller_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='咨询(es_member_ask)';

-- ----------------------------
-- Records of es_member_ask
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_collection_goods
-- ----------------------------
DROP TABLE IF EXISTS `es_member_collection_goods`;
CREATE TABLE `es_member_collection_goods` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '收藏商品ID',
  `create_time` bigint(20) DEFAULT NULL COMMENT '收藏商品时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_price` decimal(20,2) DEFAULT NULL COMMENT '商品价格',
  `goods_sn` varchar(255) DEFAULT NULL COMMENT '商品编号',
  `goods_img` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_member_collection` (`id`,`member_id`,`goods_id`,`goods_sn`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员商品收藏表(es_member_collection_goods)';

-- ----------------------------
-- Records of es_member_collection_goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_collection_shop
-- ----------------------------
DROP TABLE IF EXISTS `es_member_collection_shop`;
CREATE TABLE `es_member_collection_shop` (
  `id` bigint(20) NOT NULL COMMENT '收藏id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `shop_name` varchar(255) DEFAULT NULL COMMENT '店铺名称',
  `create_time` bigint(20) DEFAULT NULL COMMENT '收藏时间',
  `logo` varchar(255) DEFAULT NULL COMMENT '店铺logo',
  `shop_province` varchar(255) DEFAULT NULL COMMENT '店铺所在省',
  `shop_city` varchar(255) DEFAULT NULL COMMENT '店铺所在市',
  `shop_region` varchar(255) DEFAULT NULL COMMENT '店铺所在县',
  `shop_town` varchar(255) DEFAULT NULL COMMENT '店铺所在镇',
  `shop_praise_rate` decimal(20,2) DEFAULT NULL COMMENT '店铺好评率',
  `shop_description_credit` decimal(20,2) DEFAULT NULL COMMENT '店铺描述相符度',
  `shop_service_credit` decimal(20,2) DEFAULT NULL COMMENT '服务态度分数',
  `shop_delivery_credit` decimal(20,2) DEFAULT NULL COMMENT '发货速度分数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_member_collection_shop` (`id`,`member_id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员收藏店铺表(es_member_collection_shop)';

-- ----------------------------
-- Records of es_member_collection_shop
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_comment
-- ----------------------------
DROP TABLE IF EXISTS `es_member_comment`;
CREATE TABLE `es_member_comment` (
  `comment_id` bigint(20) NOT NULL COMMENT '评论主键',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `sku_id` bigint(20) DEFAULT NULL COMMENT 'skuid',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '卖家id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `member_face` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_img` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `content` longtext COMMENT '评论内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '评论时间',
  `have_image` smallint(1) DEFAULT NULL COMMENT '是否有图片 1 有 0 没有',
  `status` smallint(1) DEFAULT NULL COMMENT '状态  1 正常 0 删除 ',
  `grade` varchar(50) DEFAULT NULL COMMENT '好中差评',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `reply_status` smallint(1) DEFAULT NULL COMMENT '是否回复 1 是 0 否',
  `audit_status` varchar(255) DEFAULT 'WAIT_AUDIT' COMMENT '初评审核:待审核(WAIT_AUDIT),审核通过(PASS_AUDIT),审核拒绝(REFUSE_AUDIT)',
  `comments_type` varchar(255) DEFAULT 'INITIAL' COMMENT '评论类型：初评(INITIAL),追评(ADDITIONAL)',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '初评id，默认为0',
  PRIMARY KEY (`comment_id`) USING BTREE,
  KEY `index_member_comment` (`comment_id`,`goods_id`,`sku_id`,`member_id`,`seller_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='评论(es_member_comment)';

-- ----------------------------
-- Records of es_member_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_coupon
-- ----------------------------
DROP TABLE IF EXISTS `es_member_coupon`;
CREATE TABLE `es_member_coupon` (
  `mc_id` bigint(20) NOT NULL COMMENT '主键',
  `coupon_id` bigint(20) DEFAULT NULL COMMENT '优惠券表主键',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员表主键',
  `used_time` bigint(11) DEFAULT NULL COMMENT '使用时间',
  `create_time` bigint(11) DEFAULT NULL COMMENT '领取时间',
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单主键',
  `order_sn` varchar(30) DEFAULT NULL COMMENT '订单表主键',
  `member_name` varchar(30) DEFAULT NULL COMMENT '会员用户名',
  `title` varchar(20) DEFAULT NULL COMMENT '优惠券名称',
  `coupon_price` decimal(10,2) DEFAULT NULL COMMENT '优惠券面额',
  `coupon_threshold_price` decimal(10,2) DEFAULT NULL COMMENT '优惠券门槛金额',
  `start_time` bigint(20) DEFAULT NULL COMMENT '有效期--起始时间',
  `end_time` bigint(20) DEFAULT NULL COMMENT '有效期--截止时间',
  `used_status` smallint(1) DEFAULT NULL COMMENT '使用状态 0:未使用,1:已使用,2:已过期,3:已作废',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '商家ID',
  `seller_name` varchar(50) DEFAULT NULL COMMENT '商家名称',
  `use_scope` varchar(20) DEFAULT NULL COMMENT '使用范围 ALL:全品,CATEGORY:分类,SOME_GOODS:部分商品',
  `scope_id` longtext COMMENT '使用范围关联的id（全品或者商家优惠券时为0,分类时为分类id,部分商品时为商品ID集合）',
  PRIMARY KEY (`mc_id`) USING BTREE,
  KEY `index_member_coupon` (`mc_id`,`coupon_id`,`member_id`,`order_id`,`order_sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员优惠券(es_member_coupon)';

-- ----------------------------
-- Records of es_member_coupon
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_notice_log
-- ----------------------------
DROP TABLE IF EXISTS `es_member_notice_log`;
CREATE TABLE `es_member_notice_log` (
  `id` bigint(20) NOT NULL COMMENT '会员历史消息id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `content` longtext COMMENT '站内信内容',
  `send_time` bigint(20) DEFAULT NULL COMMENT '发送时间',
  `is_del` int(2) DEFAULT NULL COMMENT '是否删除，0删除，1没有删除',
  `is_read` int(2) DEFAULT NULL COMMENT '是否已读，0未读，1已读',
  `receive_time` bigint(20) DEFAULT NULL COMMENT '接收时间',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_member_log` (`id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员站内消息历史(es_member_notice_log)';

-- ----------------------------
-- Records of es_member_notice_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_point_history
-- ----------------------------
DROP TABLE IF EXISTS `es_member_point_history`;
CREATE TABLE `es_member_point_history` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `grade_point` bigint(20) DEFAULT NULL COMMENT '等级积分',
  `time` bigint(20) DEFAULT NULL COMMENT '操作时间',
  `reason` varchar(255) DEFAULT NULL COMMENT '操作理由',
  `grade_point_type` int(2) DEFAULT NULL COMMENT '等级积分类型',
  `operator` varchar(255) DEFAULT NULL COMMENT '操作者',
  `consum_point` bigint(20) DEFAULT NULL COMMENT '消费积分',
  `consum_point_type` int(2) DEFAULT NULL COMMENT '消费积分类型',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ind_ponit_history` (`member_id`,`grade_point_type`,`consum_point_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员积分表(es_member_point_history)';

-- ----------------------------
-- Records of es_member_point_history
-- ----------------------------
BEGIN;
INSERT INTO `es_member_point_history` VALUES (1, 51, 1, 1534837036, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (2, 16, 1, 1534837112, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (3, 25, 1, 1534840100, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (4, 27, 1, 1534840361, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (5, 50, 1, 1534847138, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (6, 50, 0, 1534847476, '创建订单，消费积分', 0, '回到过去', 1500, 0);
INSERT INTO `es_member_point_history` VALUES (7, 50, 1, 1534847495, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (8, 50, 1, 1534847503, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (9, 50, 1, 1534847510, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (10, 50, 1, 1534847519, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (11, 50, 1, 1534847526, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (12, 50, 1, 1534847539, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (13, 50, 1, 1534847551, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (14, 50, 1, 1534847559, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (15, 50, 1, 1534847566, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (16, 50, 1, 1534847579, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (17, 16, 1, 1534847589, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (18, 50, 1, 1534847595, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (19, 50, 1, 1534847605, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (20, 50, 1, 1534847611, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (21, 50, 1, 1534847616, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (22, 50, 1, 1534847624, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (23, 27, 1, 1534848168, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (24, 27, 1, 1534848175, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (25, 27, 1, 1534848181, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (26, 27, 1, 1534848186, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (27, 27, 1, 1534848191, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (28, 27, 1, 1534848196, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (29, 27, 1, 1534848201, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (30, 27, 1, 1534848206, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (31, 27, 1, 1534848211, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (32, 27, 1, 1534848218, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (33, 27, 1, 1534848225, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (34, 27, 1, 1534848230, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (35, 27, 1, 1534848235, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (36, 27, 1, 1534848240, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (37, 27, 1, 1534848245, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (38, 27, 1, 1534848251, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (39, 27, 1, 1534848260, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (40, 27, 1, 1534848265, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (41, 27, 1, 1534848270, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (42, 27, 1, 1534848275, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (43, 2, 1, 1534848992, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (44, 16, 1, 1534849544, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (45, 16, 1, 1534849567, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (46, 16, 1, 1534849574, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (47, 16, 1, 1534849579, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (48, 27, 1, 1534849585, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (49, 27, 1, 1534849590, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (50, 27, 1, 1534849595, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (51, 27, 1, 1534849600, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (52, 27, 1, 1534849605, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (53, 27, 1, 1534849610, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (54, 27, 1, 1534849615, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (55, 27, 1, 1534849624, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (56, 46, 1, 1534849708, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (57, 46, 1, 1534849824, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (58, 46, 1, 1534849829, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (59, 46, 1, 1534849834, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (60, 46, 1, 1534849839, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (61, 46, 1, 1534849844, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (62, 46, 1, 1534849848, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (63, 11, 1, 1534852395, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (64, 6, 1, 1534852504, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (65, 26, 1, 1534852535, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (66, 16, 1, 1534852799, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (67, 16, 1, 1534852799, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (68, 16, 1, 1534852812, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (69, 16, 1, 1534852822, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (70, 16, 1, 1534852831, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (71, 16, 1, 1534852839, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (72, 16, 10, 1534852839, '每个商品首次评论', 1, '系统', 10, 1);
INSERT INTO `es_member_point_history` VALUES (73, 27, 1, 1534852917, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (74, 27, 1, 1534852925, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (75, 27, 1, 1534852933, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (76, 27, 1, 1534852942, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (77, 27, 1, 1534852950, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (78, 27, 10, 1534852950, '每个商品首次评论', 1, '系统', 10, 1);
INSERT INTO `es_member_point_history` VALUES (79, 27, 1, 1534852963, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (80, 27, 1, 1534852978, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (81, 27, 1, 1534852993, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (82, 27, 1, 1534853006, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (83, 27, 10, 1534853006, '每个商品首次评论', 1, '系统', 10, 1);
INSERT INTO `es_member_point_history` VALUES (84, 27, 1, 1534853006, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (85, 27, 1, 1534853006, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (86, 27, 1, 1534853006, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (87, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (88, 27, 10, 1534853024, '每个商品首次评论', 1, '系统', 10, 1);
INSERT INTO `es_member_point_history` VALUES (89, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (90, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (91, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (92, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (93, 27, 1, 1534853024, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (94, 27, 1, 1534853097, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (95, 27, 1, 1534853116, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (96, 27, 1, 1534853116, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (97, 27, 1, 1534853126, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (98, 27, 1, 1534853136, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (99, 27, 1, 1534853150, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (100, 27, 1, 1534853162, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (101, 27, 1, 1534853162, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (102, 27, 1, 1534853584, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (103, 27, 1, 1534853592, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (104, 27, 1, 1534853606, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (105, 27, 1, 1534853616, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (106, 27, 10, 1534853616, '每个商品首次评论', 1, '系统', 10, 1);
INSERT INTO `es_member_point_history` VALUES (107, 27, 1, 1534853638, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (108, 27, 1, 1534854198, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (109, 16, 1, 1534855418, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (110, 16, 1, 1534855509, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (111, 16, 1, 1534855656, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (112, 16, 1, 1534855805, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (113, 16, 1, 1534855850, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (114, 27, 1, 1534860204, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (115, 27, 0, 1534867201, '订单取消，退还消费积分', 0, 'appliance', 0, 1);
INSERT INTO `es_member_point_history` VALUES (116, 27, 0, 1534867201, '订单取消，退还消费积分', 0, 'appliance', 0, 1);
INSERT INTO `es_member_point_history` VALUES (117, 27, 0, 1534867202, '订单取消，退还消费积分', 0, 'appliance', 0, 1);
INSERT INTO `es_member_point_history` VALUES (118, 27, 0, 1534867202, '订单取消，退还消费积分', 0, 'appliance', 0, 1);
INSERT INTO `es_member_point_history` VALUES (119, 16, 67, 1534867208, '购买商品送积分', 1, '系统', 67, 1);
INSERT INTO `es_member_point_history` VALUES (120, 27, 1049, 1534867208, '购买商品送积分', 1, '系统', 1049, 1);
INSERT INTO `es_member_point_history` VALUES (121, 27, 2999, 1534867208, '购买商品送积分', 1, '系统', 2999, 1);
INSERT INTO `es_member_point_history` VALUES (122, 27, 3699, 1534867208, '购买商品送积分', 1, '系统', 3699, 1);
INSERT INTO `es_member_point_history` VALUES (123, 27, 1299, 1534867208, '购买商品送积分', 1, '系统', 1299, 1);
INSERT INTO `es_member_point_history` VALUES (124, 27, 2599, 1534867209, '购买商品送积分', 1, '系统', 2599, 1);
INSERT INTO `es_member_point_history` VALUES (125, 27, 4198, 1534867209, '购买商品送积分', 1, '系统', 4198, 1);
INSERT INTO `es_member_point_history` VALUES (126, 27, 399, 1534867209, '购买商品送积分', 1, '系统', 399, 1);
INSERT INTO `es_member_point_history` VALUES (127, 27, 6798, 1534867209, '购买商品送积分', 1, '系统', 6798, 1);
INSERT INTO `es_member_point_history` VALUES (128, 27, 399, 1534867210, '购买商品送积分', 1, '系统', 399, 1);
INSERT INTO `es_member_point_history` VALUES (129, 27, 10198, 1534867210, '购买商品送积分', 1, '系统', 10198, 1);
INSERT INTO `es_member_point_history` VALUES (130, 27, 1738, 1534867210, '购买商品送积分', 1, '系统', 1738, 1);
INSERT INTO `es_member_point_history` VALUES (131, 27, 3699, 1534867210, '购买商品送积分', 1, '系统', 3699, 1);
INSERT INTO `es_member_point_history` VALUES (132, 27, 120, 1534867210, '购买商品送积分', 1, '系统', 120, 1);
INSERT INTO `es_member_point_history` VALUES (133, 27, 1778, 1534867211, '购买商品送积分', 1, '系统', 1778, 1);
INSERT INTO `es_member_point_history` VALUES (134, 27, 4799, 1534867211, '购买商品送积分', 1, '系统', 4799, 1);
INSERT INTO `es_member_point_history` VALUES (135, 27, 19337, 1534867211, '购买商品送积分', 1, '系统', 19337, 1);
INSERT INTO `es_member_point_history` VALUES (136, 27, 62861, 1534867211, '购买商品送积分', 1, '系统', 62861, 1);
INSERT INTO `es_member_point_history` VALUES (137, 27, 4556, 1534867212, '购买商品送积分', 1, '系统', 4556, 1);
INSERT INTO `es_member_point_history` VALUES (138, 27, 385, 1534867212, '购买商品送积分', 1, '系统', 385, 1);
INSERT INTO `es_member_point_history` VALUES (139, 27, 25, 1534867212, '购买商品送积分', 1, '系统', 25, 1);
INSERT INTO `es_member_point_history` VALUES (140, 27, 58, 1534867212, '购买商品送积分', 1, '系统', 58, 1);
INSERT INTO `es_member_point_history` VALUES (141, 27, 198, 1534867213, '购买商品送积分', 1, '系统', 198, 1);
INSERT INTO `es_member_point_history` VALUES (142, 27, 135, 1534867213, '购买商品送积分', 1, '系统', 135, 1);
INSERT INTO `es_member_point_history` VALUES (143, 27, 59, 1534867213, '购买商品送积分', 1, '系统', 59, 1);
INSERT INTO `es_member_point_history` VALUES (144, 27, 996, 1534867213, '购买商品送积分', 1, '系统', 996, 1);
INSERT INTO `es_member_point_history` VALUES (145, 27, 239, 1534867213, '购买商品送积分', 1, '系统', 239, 1);
INSERT INTO `es_member_point_history` VALUES (146, 16, 199, 1534867213, '购买商品送积分', 1, '系统', 199, 1);
INSERT INTO `es_member_point_history` VALUES (147, 16, 6184, 1534867213, '购买商品送积分', 1, '系统', 6184, 1);
INSERT INTO `es_member_point_history` VALUES (148, 16, 159, 1534867214, '购买商品送积分', 1, '系统', 159, 1);
INSERT INTO `es_member_point_history` VALUES (149, 16, 18447, 1534867214, '购买商品送积分', 1, '系统', 18447, 1);
INSERT INTO `es_member_point_history` VALUES (150, 27, 519, 1534867214, '购买商品送积分', 1, '系统', 519, 1);
INSERT INTO `es_member_point_history` VALUES (151, 16, 25, 1534867214, '购买商品送积分', 1, '系统', 25, 1);
INSERT INTO `es_member_point_history` VALUES (152, 16, 77, 1534867214, '购买商品送积分', 1, '系统', 77, 1);
INSERT INTO `es_member_point_history` VALUES (153, 16, 31, 1534867215, '购买商品送积分', 1, '系统', 31, 1);
INSERT INTO `es_member_point_history` VALUES (154, 16, 1, 1534900699, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (155, 51, 1, 1534909106, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (156, 27, 1, 1534910770, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (157, 52, 1, 1534917930, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (158, 2, 1, 1534918721, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (159, 51, 0, 1534953602, '订单取消，退还消费积分', 0, 'm_18555555555', 0, 1);
INSERT INTO `es_member_point_history` VALUES (160, 50, 6099, 1534953603, '购买商品送积分', 1, '系统', 6099, 1);
INSERT INTO `es_member_point_history` VALUES (161, 50, 1596, 1534953603, '购买商品送积分', 1, '系统', 1596, 1);
INSERT INTO `es_member_point_history` VALUES (162, 50, 2299, 1534953603, '购买商品送积分', 1, '系统', 2299, 1);
INSERT INTO `es_member_point_history` VALUES (163, 50, 189, 1534953603, '购买商品送积分', 1, '系统', 189, 1);
INSERT INTO `es_member_point_history` VALUES (164, 50, 2299, 1534953604, '购买商品送积分', 1, '系统', 2299, 1);
INSERT INTO `es_member_point_history` VALUES (165, 50, 3697, 1534953604, '购买商品送积分', 1, '系统', 3697, 1);
INSERT INTO `es_member_point_history` VALUES (166, 50, 1199, 1534953604, '购买商品送积分', 1, '系统', 1199, 1);
INSERT INTO `es_member_point_history` VALUES (167, 50, 2997, 1534953604, '购买商品送积分', 1, '系统', 2997, 1);
INSERT INTO `es_member_point_history` VALUES (168, 50, 3182, 1534953605, '购买商品送积分', 1, '系统', 3182, 1);
INSERT INTO `es_member_point_history` VALUES (169, 50, 6486, 1534953605, '购买商品送积分', 1, '系统', 6486, 1);
INSERT INTO `es_member_point_history` VALUES (170, 50, 11997, 1534953605, '购买商品送积分', 1, '系统', 11997, 1);
INSERT INTO `es_member_point_history` VALUES (171, 50, 11999, 1534953605, '购买商品送积分', 1, '系统', 11999, 1);
INSERT INTO `es_member_point_history` VALUES (172, 50, 15, 1534953605, '购买商品送积分', 1, '系统', 15, 1);
INSERT INTO `es_member_point_history` VALUES (173, 50, 22597, 1534953606, '购买商品送积分', 1, '系统', 22597, 1);
INSERT INTO `es_member_point_history` VALUES (174, 50, 249, 1534953606, '购买商品送积分', 1, '系统', 249, 1);
INSERT INTO `es_member_point_history` VALUES (175, 46, 4788, 1534953606, '购买商品送积分', 1, '系统', 4788, 1);
INSERT INTO `es_member_point_history` VALUES (176, 46, 16495, 1534953606, '购买商品送积分', 1, '系统', 16495, 1);
INSERT INTO `es_member_point_history` VALUES (177, 46, 3897, 1534953607, '购买商品送积分', 1, '系统', 3897, 1);
INSERT INTO `es_member_point_history` VALUES (178, 46, 429, 1534953607, '购买商品送积分', 1, '系统', 429, 1);
INSERT INTO `es_member_point_history` VALUES (179, 46, 4022, 1534953607, '购买商品送积分', 1, '系统', 4022, 1);
INSERT INTO `es_member_point_history` VALUES (180, 2, 25, 1534953607, '购买商品送积分', 1, '系统', 25, 1);
INSERT INTO `es_member_point_history` VALUES (181, 16, 1, 1534991050, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (182, 51, 1, 1535004837, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (183, 27, 1, 1535004880, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (184, 51, 1, 1535005135, '图片评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (185, 51, 1, 1535005365, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (186, 51, 1, 1535005451, '图片评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (187, 16, 1, 1535005824, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (188, 51, 1, 1535010526, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (189, 51, 999, 1535040002, '购买商品送积分', 1, '系统', 999, 1);
INSERT INTO `es_member_point_history` VALUES (190, 51, 999, 1535040002, '购买商品送积分', 1, '系统', 999, 1);
INSERT INTO `es_member_point_history` VALUES (191, 51, 1, 1535075722, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (192, 27, 1, 1535076356, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (193, 2, 1, 1535100914, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (194, 52, 1, 1535100978, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (195, 52, 0, 1535126401, '订单取消，退还消费积分', 0, 'fengkun', 0, 1);
INSERT INTO `es_member_point_history` VALUES (196, 16, 60, 1535126401, '购买商品送积分', 1, '系统', 60, 1);
INSERT INTO `es_member_point_history` VALUES (197, 51, 190, 1535212801, '购买商品送积分', 1, '系统', 190, 1);
INSERT INTO `es_member_point_history` VALUES (198, 2, 1, 1535283181, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (199, 26, 1, 1535338916, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (200, 27, 1, 1535339051, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (201, 25, 1, 1535339154, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (202, 16, 1, 1535340642, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (203, 53, 1, 1535340715, '会员注册送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (204, 53, 1, 1535340715, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (205, 53, 0, 1535341058, '订单取消，退还消费积分', 0, 'chopper', 0, 1);
INSERT INTO `es_member_point_history` VALUES (206, 53, 1, 1535341141, '在线支付送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (207, 2, 1, 1535353721, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (208, 2, 1, 1535370972, '文字评论送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (209, 27, 1, 1535418382, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (210, 26, 1, 1535419187, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (211, 25, 1, 1535419460, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (212, 47, 1, 1535438520, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (213, 54, 1, 1535442163, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (214, 55, 1, 1535443163, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (215, 2, 1, 1535444112, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (216, 46, 1, 1535445904, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (220, 27, 0, 1535462984, '订单取消，退还消费积分', 0, 'appliance', 0, 1);
INSERT INTO `es_member_point_history` VALUES (221, 25, 1, 1535504609, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (222, 27, 1, 1535505893, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (223, 55, 1, 1535507093, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (224, 2, 1, 1535509769, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (225, 2, 1, 1536046991, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (226, 45, 1, 1536301632, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (227, 16, 1, 1536303849, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (228, 45, 1, 1545731873, '每天首次登录送积分', 1, '系统', 1, 1);
INSERT INTO `es_member_point_history` VALUES (229, 45, 1, 1545731945, '在线支付送积分', 1, '系统', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for es_member_receipt
-- ----------------------------
DROP TABLE IF EXISTS `es_member_receipt`;
CREATE TABLE `es_member_receipt` (
  `receipt_id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `receipt_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票类型 ELECTRO：电子普通发票，VATORDINARY：增值税普通发票',
  `receipt_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票抬头',
  `receipt_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票内容',
  `tax_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纳税人识别号',
  `member_mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人手机号',
  `member_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人邮箱',
  `is_default` smallint(1) DEFAULT NULL COMMENT '是否为默认选项 0：否，1：是',
  PRIMARY KEY (`receipt_id`) USING BTREE,
  KEY `index_member_receipt` (`receipt_id`,`receipt_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员发票信息缓存表(es_member_receipt)';

-- ----------------------------
-- Records of es_member_receipt
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_shop_score
-- ----------------------------
DROP TABLE IF EXISTS `es_member_shop_score`;
CREATE TABLE `es_member_shop_score` (
  `score_id` bigint(20) NOT NULL COMMENT '主键',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `delivery_score` smallint(1) DEFAULT NULL COMMENT '发货速度评分',
  `description_score` smallint(1) DEFAULT NULL COMMENT '描述相符度评分',
  `service_score` smallint(1) DEFAULT NULL COMMENT '服务评分',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '卖家',
  PRIMARY KEY (`score_id`) USING BTREE,
  KEY `index_member_shop_score` (`score_id`,`member_id`,`order_sn`,`seller_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺评分(es_member_shop_score)';

-- ----------------------------
-- Records of es_member_shop_score
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_member_wallet
-- ----------------------------
DROP TABLE IF EXISTS `es_member_wallet`;
CREATE TABLE `es_member_wallet` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '会员名称',
  `pre_deposite` decimal(20,2) DEFAULT NULL COMMENT '会员预存款，默认为0',
  `deposite_password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '预存款密码，默认为-1',
  `sign` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sign_result` int(1) DEFAULT '0',
  `scan_rounds` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_member_wallet` (`id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;


-- ----------------------------
-- Records of es_member_wallet
-- ----------------------------
BEGIN;
INSERT INTO `es_member_wallet` VALUES ('1', '54', 'AAA', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('2', '41', 'antman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('3', '27', 'appliance', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('4', '39', 'batman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('5', '47', 'black', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('6', '46', 'blue', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('7', '53', 'chopper', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('8', '6', 'demo_woman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('9', '44', 'eagle', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('10', '52', 'fengkun', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('11', '16', 'food', '9949.99', 'db383ded6a3f1efe1b9e9be146bdeae0', 'c927fc132035206074ebd3846fbd3c53', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('12', '45', 'green', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('13', '43', 'hock', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('14', '42', 'ironman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('15', '33', 'java', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('16', '2', 'javashop', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('17', '55', 'javashop7', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('18', '28', 'kanon', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('19', '26', 'kans', '9771.00', 'cc5f295e4c8b28b5ff6d0a378005fe2f', '7c7b71ec03c6b692194596f619d4d716', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('20', '48', 'lion', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('21', '32', 'martin', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('22', '51', 'm_18555555555', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('23', '40', 'spiderman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('24', '31', 'spring', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('25', '25', 'superman', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('26', '11', 'toys', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('27', '29', 'wanghui', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('28', '30', 'xulipeng', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('29', '38', '下个路口见', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('30', '34', '六月的雨', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('31', '50', '回到过去', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('32', '37', '春风十里_不如你', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('33', '36', '秋刀鱼的滋味', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('34', '35', '陈冠希_', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('35', '49', '麦芽糖_', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');
INSERT INTO `es_member_wallet` VALUES ('1470959848900595713', '1470959847998828545', 'ceshi', '0.00', '-1', '6e969c919f607467a2a39d3b970808f9', '1', '202117');

COMMIT;

-- ----------------------------
-- Table structure for es_member_zpzz
-- ----------------------------
DROP TABLE IF EXISTS `es_member_zpzz`;
CREATE TABLE `es_member_zpzz` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `uname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员用户名',
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态 NEW_APPLY：新申请，AUDIT_PASS：审核通过，AUDIT_REFUSE：审核未通过',
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '单位名称',
  `taxpayer_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纳税人识别码',
  `register_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司注册地址',
  `register_tel` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司注册电话',
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户银行',
  `bank_account` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行账户',
  `audit_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '平台审核备注',
  `apply_time` bigint(20) DEFAULT NULL COMMENT '申请时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_member_zpzz` (`id`,`member_id`,`uname`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='会员增票资质表(es_member_zpzz)';

-- ----------------------------
-- Records of es_member_zpzz
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_navigation
-- ----------------------------
DROP TABLE IF EXISTS `es_navigation`;
CREATE TABLE `es_navigation` (
  `id` bigint(20) NOT NULL COMMENT '导航id',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `disable` int(10) DEFAULT NULL COMMENT '是否显示',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `nav_url` varchar(255) DEFAULT NULL COMMENT 'URL',
  `target` int(10) DEFAULT NULL COMMENT '新窗口打开',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `contents` varchar(255) DEFAULT NULL COMMENT '内容',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_navition` (`id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺导航管理(es_navigation)';

-- ----------------------------
-- Records of es_navigation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_receipt_address
-- ----------------------------
DROP TABLE IF EXISTS `es_receipt_address`;
CREATE TABLE `es_receipt_address` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `member_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人姓名',
  `member_mobile` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人手机号',
  `province_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属省份ID',
  `city_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属城市ID',
  `county_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属区县ID',
  `town_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属乡镇ID',
  `province` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属省份',
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属城市',
  `county` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属区县',
  `town` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属乡镇',
  `detail_addr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-详细地址',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_receipt_address` (`id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='会员收票地址表(es_receipt_address)';

-- ----------------------------
-- Records of es_receipt_address
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_receipt_file
-- ----------------------------
DROP TABLE IF EXISTS `es_receipt_file`;
CREATE TABLE `es_receipt_file` (
  `id` bigint(20) NOT NULL,
  `history_id` bigint(20) DEFAULT NULL,
  `elec_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_receipt_file` (`id`,`history_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='会员电子发票附件表(es_receipt_file)';

-- ----------------------------
-- Records of es_receipt_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_receipt_history
-- ----------------------------
DROP TABLE IF EXISTS `es_receipt_history`;
CREATE TABLE `es_receipt_history` (
  `history_id` bigint(20) NOT NULL COMMENT '主键ID',
  `order_sn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单编号',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '开票商家ID',
  `seller_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开票商家',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `status` smallint(1) DEFAULT NULL COMMENT '开票状态 0：未开，1：已开',
  `receipt_method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开票方式(针对增值税专用发票)',
  `receipt_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票类型 ELECTRO：电子普通发票，VATORDINARY：增值税普通发票，VATOSPECIAL：增值税专用发票',
  `logi_id` bigint(20) DEFAULT NULL COMMENT '物流公司ID',
  `logi_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流公司名称',
  `logi_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '快递单号',
  `receipt_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票抬头',
  `receipt_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票内容',
  `tax_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纳税人识别号',
  `reg_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '注册地址',
  `reg_tel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '注册电话',
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户银行',
  `bank_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行账户',
  `member_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人名称',
  `member_mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人手机号',
  `member_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票人邮箱',
  `province_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属省份ID',
  `city_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属城市ID',
  `county_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属区县ID',
  `town_id` bigint(20) DEFAULT NULL COMMENT '收票地址-所属乡镇ID',
  `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属省份',
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属城市',
  `county` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属区县',
  `town` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-所属乡镇',
  `detail_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收票地址-详细地址',
  `add_time` bigint(20) DEFAULT NULL COMMENT '申请开票日期',
  `goods_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '订单商品信息',
  `order_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单出库状态，NEW/CONFIRM',
  `uname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员名称',
  PRIMARY KEY (`history_id`) USING BTREE,
  KEY `index_receipt_history` (`history_id`,`order_sn`,`seller_id`,`member_id`,`logi_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员开票历史记录表(es_receipt_history)';

-- ----------------------------
-- Records of es_receipt_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_ship_template
-- ----------------------------
DROP TABLE IF EXISTS `es_ship_template`;
CREATE TABLE `es_ship_template` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '卖家id',
  `name` varchar(255) DEFAULT NULL COMMENT '模板名称',
  `type` smallint(1) DEFAULT NULL COMMENT '1 重量算运费 2 计件算运费',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_ship_template` (`id`,`seller_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='运费模版(es_ship_template)';

-- ----------------------------
-- Records of es_ship_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_ship_template_child
-- ----------------------------
DROP TABLE IF EXISTS `es_ship_template_child`;
CREATE TABLE `es_ship_template_child` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `template_id` bigint(20) DEFAULT NULL COMMENT '外键  模板id',
  `first_company` int(10) DEFAULT NULL COMMENT '首个（件）',
  `first_price` decimal(20,2) DEFAULT NULL COMMENT '首个（件）价格',
  `continued_company` int(10) DEFAULT NULL COMMENT '续个（件）',
  `continued_price` decimal(20,2) DEFAULT NULL COMMENT '续个（件）价格',
  `area` longtext COMMENT '地区json',
  `area_id` longtext COMMENT '地区id',
  `is_free` int(1) DEFAULT '0' COMMENT '是否免运费  0:不免运费   1：免运费 ',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_ship_template_child` (`id`,`template_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='运费模板子模板(es_ship_template_child)';

-- ----------------------------
-- Records of es_ship_template_child
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_shop
-- ----------------------------
DROP TABLE IF EXISTS `es_shop`;
CREATE TABLE `es_shop` (
  `shop_id` bigint(20) NOT NULL COMMENT '店铺Id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员Id',
  `member_name` varchar(50) DEFAULT NULL COMMENT '会员名称',
  `shop_name` varchar(255) DEFAULT NULL COMMENT '店铺名称',
  `shop_disable` varchar(50) DEFAULT NULL COMMENT '店铺状态',
  `shop_createtime` bigint(20) DEFAULT NULL COMMENT '店铺创建时间',
  `shop_endtime` bigint(20) DEFAULT NULL COMMENT '店铺关闭时间',
  PRIMARY KEY (`shop_id`) USING BTREE,
  KEY `index_shop` (`shop_id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺(es_shop)';

-- ----------------------------
-- Records of es_shop
-- ----------------------------
BEGIN;
INSERT INTO `es_shop` VALUES (1, 2, 'lifenlong', '平台自营', 'OPEN', 0, 0);
INSERT INTO `es_shop` VALUES (5, 6, 'demo_woman', '时尚女装/搭配', 'OPEN', 1427854939, 0);
INSERT INTO `es_shop` VALUES (10, 11, 'toys', '母婴和玩具', 'OPEN', 1427962215, 0);
INSERT INTO `es_shop` VALUES (15, 16, 'food', '食品酒水', 'OPEN', 1428651347, 0);
INSERT INTO `es_shop` VALUES (16, 25, 'superman', 'superman', 'OPEN', 1464430981, 0);
INSERT INTO `es_shop` VALUES (17, 26, 'kans', '化妆品店铺', 'OPEN', 1464509176, 0);
INSERT INTO `es_shop` VALUES (18, 27, 'appliance', '数码家电', 'OPEN', 1508507143, 0);
INSERT INTO `es_shop` VALUES ('1470960016404328449', '1470959847998828545', 'ceshi', '泡泡玛特盲盒小店', 'OPEN', '1639539263', null);
COMMIT;

-- ----------------------------
-- Table structure for es_shop_cat
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_cat`;
CREATE TABLE `es_shop_cat` (
  `shop_cat_id` bigint(20) NOT NULL COMMENT '店铺分组id',
  `shop_cat_pid` bigint(20) DEFAULT NULL COMMENT '店铺分组父ID',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `shop_cat_name` varchar(50) DEFAULT NULL COMMENT '店铺分组名称',
  `disable` int(10) DEFAULT NULL COMMENT '店铺分组显示状态:1显示 0不显示',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `cat_path` varchar(50) DEFAULT NULL COMMENT '分组路径',
  PRIMARY KEY (`shop_cat_id`) USING BTREE,
  KEY `es_shop_cat_shopid` (`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺分组(es_shop_cat)';

-- ----------------------------
-- Records of es_shop_cat
-- ----------------------------
BEGIN;
INSERT INTO `es_shop_cat` VALUES (1, 0, 1, '食品服装', 1, 2, '0|1|');
INSERT INTO `es_shop_cat` VALUES (2, 0, 15, '测试分类', 1, 0, '0|2|');
INSERT INTO `es_shop_cat` VALUES (3, 0, 15, '饼干', 1, 0, '0|3|');
INSERT INTO `es_shop_cat` VALUES (4, 0, 15, '饮料', 1, 0, '0|4|');
INSERT INTO `es_shop_cat` VALUES (5, 0, 15, '酒水', 1, 0, '0|5|');
INSERT INTO `es_shop_cat` VALUES (6, 0, 15, '牛奶乳品', 1, 0, '0|6|');
INSERT INTO `es_shop_cat` VALUES (7, 0, 15, '零食', 1, 0, '0|7|');
INSERT INTO `es_shop_cat` VALUES (8, 0, 15, '糖果', 1, 0, '0|8|');
INSERT INTO `es_shop_cat` VALUES (9, 0, 5, '衬衫', 1, 0, '0|9|');
INSERT INTO `es_shop_cat` VALUES (10, 0, 5, '裙子', 1, 0, '0|10|');
INSERT INTO `es_shop_cat` VALUES (11, 0, 5, '裤子', 1, 0, '0|11|');
INSERT INTO `es_shop_cat` VALUES (12, 0, 16, '衬衣', 1, 0, '0|12|');
INSERT INTO `es_shop_cat` VALUES (13, 0, 16, '西裤', 1, 0, '0|13|');
INSERT INTO `es_shop_cat` VALUES (14, 0, 16, 'T恤', 1, 0, '0|14|');
INSERT INTO `es_shop_cat` VALUES (15, 0, 16, '鞋子', 1, 0, '0|15|');
INSERT INTO `es_shop_cat` VALUES (16, 15, 16, '男鞋', 1, 0, '0|15|16|');
INSERT INTO `es_shop_cat` VALUES (17, 15, 16, '女鞋', 1, 0, '0|15|17|');
INSERT INTO `es_shop_cat` VALUES (18, 0, 17, '化妆水', 1, 0, '0|18|');
INSERT INTO `es_shop_cat` VALUES (19, 0, 17, '面霜', 1, 0, '0|19|');
INSERT INTO `es_shop_cat` VALUES (20, 0, 17, '眼霜', 1, 0, '0|20|');
INSERT INTO `es_shop_cat` VALUES (21, 0, 17, '润肤乳', 1, 0, '0|21|');
INSERT INTO `es_shop_cat` VALUES (22, 0, 17, '洗面奶', 1, 0, '0|22|');
INSERT INTO `es_shop_cat` VALUES (23, 0, 17, '防晒', 1, 0, '0|23|');
INSERT INTO `es_shop_cat` VALUES (24, 0, 17, '面膜', 1, 0, '0|24|');
INSERT INTO `es_shop_cat` VALUES (25, 0, 17, '彩妆', 1, 0, '0|25|');
INSERT INTO `es_shop_cat` VALUES (26, 0, 17, '卸妆', 1, 0, '0|26|');
INSERT INTO `es_shop_cat` VALUES (27, 0, 18, '电子数码', 1, 1, '0|27|');
INSERT INTO `es_shop_cat` VALUES (28, 0, 18, '大型家电', 1, 2, '0|28|');
INSERT INTO `es_shop_cat` VALUES (29, 0, 1, '厨房小电', 1, 1, '0|29|');
INSERT INTO `es_shop_cat` VALUES (30, 0, 1, '电脑设备', 1, 2, '0|30|');
INSERT INTO `es_shop_cat` VALUES (31, 28, 18, '全自动', 1, 1, '0|28|31|');
INSERT INTO `es_shop_cat` VALUES (32, 28, 18, '半自动', 1, 2, '0|28|32|');
INSERT INTO `es_shop_cat` VALUES (33, 0, 1, '家用电器', 1, 0, '0|33|');
INSERT INTO `es_shop_cat` VALUES (34, 0, 1, '新品上架', 1, 0, '0|34|');
INSERT INTO `es_shop_cat` VALUES (35, 1, 1, '订单', 1, 0, '0|1|35|');
COMMIT;

-- ----------------------------
-- Table structure for es_shop_detail
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_detail`;
CREATE TABLE `es_shop_detail` (
  `id` bigint(20) NOT NULL COMMENT '店铺详细id',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `shop_province_id` bigint(20) DEFAULT NULL COMMENT '店铺所在省id',
  `shop_city_id` bigint(20) DEFAULT NULL COMMENT '店铺所在市id',
  `shop_county_id` bigint(20) DEFAULT NULL COMMENT '店铺所在县id',
  `shop_town_id` bigint(20) DEFAULT NULL COMMENT '店铺所在镇id',
  `shop_province` varchar(50) DEFAULT NULL COMMENT '店铺所在省',
  `shop_city` varchar(50) DEFAULT NULL COMMENT '店铺所在市',
  `shop_county` varchar(50) DEFAULT NULL COMMENT '店铺所在县',
  `shop_town` varchar(50) DEFAULT NULL COMMENT '店铺所在镇',
  `shop_add` varchar(255) DEFAULT NULL COMMENT '店铺详细地址',
  `company_name` varchar(255) DEFAULT NULL COMMENT '公司名称',
  `company_address` varchar(255) DEFAULT NULL COMMENT '公司地址',
  `company_phone` varchar(255) DEFAULT NULL COMMENT '公司电话',
  `company_email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `employee_num` int(10) DEFAULT NULL COMMENT '员工总数',
  `reg_money` decimal(20,2) DEFAULT NULL COMMENT '注册资金',
  `link_name` varchar(50) DEFAULT NULL COMMENT '联系人姓名',
  `link_phone` varchar(50) DEFAULT NULL COMMENT '联系人电话',
  `legal_name` varchar(50) DEFAULT NULL COMMENT '法人姓名',
  `legal_id` varchar(255) DEFAULT NULL COMMENT '法人身份证',
  `legal_img` varchar(255) DEFAULT NULL COMMENT '法人身份证照片',
  `license_num` varchar(50) DEFAULT NULL COMMENT '营业执照号',
  `license_province_id` bigint(20) DEFAULT NULL COMMENT '营业执照所在省id',
  `license_city_id` bigint(20) DEFAULT NULL COMMENT '营业执照所在市id',
  `license_county_id` bigint(20) DEFAULT NULL COMMENT '营业执照所在县id',
  `license_town_id` bigint(20) DEFAULT NULL COMMENT '营业执照所在镇id',
  `license_province` varchar(50) DEFAULT NULL COMMENT '营业执照所在省',
  `license_city` varchar(50) DEFAULT NULL COMMENT '营业执照所在市',
  `license_county` varchar(50) DEFAULT NULL COMMENT '营业执照所在县',
  `license_town` varchar(50) DEFAULT NULL COMMENT '营业执照所在镇',
  `license_add` varchar(255) DEFAULT NULL COMMENT '营业执照详细地址',
  `establish_date` bigint(20) DEFAULT NULL COMMENT '成立日期',
  `licence_start` bigint(20) DEFAULT NULL COMMENT '营业执照有效期开始',
  `licence_end` bigint(20) DEFAULT NULL COMMENT '营业执照有效期结束',
  `scope` varchar(255) DEFAULT NULL COMMENT '法定经营范围',
  `licence_img` varchar(255) DEFAULT NULL COMMENT '营业执照电子版',
  `organization_code` varchar(255) DEFAULT NULL COMMENT '组织机构代码',
  `code_img` varchar(255) DEFAULT NULL COMMENT '组织机构电子版',
  `taxes_img` varchar(255) DEFAULT NULL COMMENT '一般纳税人证明电子版',
  `bank_account_name` varchar(50) DEFAULT NULL COMMENT '银行开户名',
  `bank_number` varchar(255) DEFAULT NULL COMMENT '银行开户账号',
  `bank_name` varchar(255) DEFAULT NULL COMMENT '开户银行支行名称',
  `bank_province_id` bigint(20) DEFAULT NULL COMMENT '开户银行所在省id',
  `bank_city_id` bigint(20) DEFAULT NULL COMMENT '开户银行所在市id',
  `bank_county_id` bigint(20) DEFAULT NULL COMMENT '开户银行所在县id',
  `bank_town_id` bigint(20) DEFAULT NULL COMMENT '开户银行所在镇id',
  `bank_province` varchar(50) DEFAULT NULL COMMENT '开户银行所在省',
  `bank_city` varchar(50) DEFAULT NULL COMMENT '开户银行所在市',
  `bank_county` varchar(50) DEFAULT NULL COMMENT '开户银行所在县',
  `bank_town` varchar(50) DEFAULT NULL COMMENT '开户银行所在镇',
  `bank_img` varchar(255) DEFAULT NULL COMMENT '开户银行许可证电子版',
  `taxes_certificate_num` varchar(50) DEFAULT NULL COMMENT '税务登记证号',
  `taxes_distinguish_num` varchar(50) DEFAULT NULL COMMENT '纳税人识别号',
  `taxes_certificate_img` varchar(255) DEFAULT NULL COMMENT '税务登记证书',
  `goods_management_category` longtext COMMENT '店铺经营类目',
  `shop_level` int(10) DEFAULT NULL COMMENT '店铺等级',
  `shop_level_apply` int(10) DEFAULT NULL COMMENT '店铺等级申请',
  `store_space_capacity` decimal(10,2) DEFAULT NULL COMMENT '店铺相册已用存储量',
  `shop_logo` varchar(255) DEFAULT NULL COMMENT '店铺logo',
  `shop_banner` varchar(255) DEFAULT NULL COMMENT '店铺横幅',
  `shop_desc` longtext COMMENT '店铺简介',
  `shop_recommend` int(10) DEFAULT NULL COMMENT '是否推荐',
  `shop_themeid` bigint(20) DEFAULT NULL COMMENT '店铺主题id',
  `shop_theme_path` varchar(50) DEFAULT NULL COMMENT '店铺主题模版路径',
  `wap_themeid` bigint(20) DEFAULT NULL COMMENT '店铺主题id',
  `wap_theme_path` varchar(50) DEFAULT NULL COMMENT 'wap店铺主题',
  `shop_credit` decimal(20,2) DEFAULT NULL COMMENT '店铺信用',
  `shop_praise_rate` decimal(10,2) DEFAULT NULL COMMENT '店铺好评率',
  `shop_description_credit` decimal(10,2) DEFAULT NULL COMMENT '店铺描述相符度',
  `shop_service_credit` decimal(10,2) DEFAULT NULL COMMENT '服务态度分数',
  `shop_delivery_credit` decimal(10,2) DEFAULT NULL COMMENT '发货速度分数',
  `shop_collect` int(10) DEFAULT NULL COMMENT '店铺收藏数',
  `goods_num` int(10) DEFAULT NULL COMMENT '店铺商品数',
  `shop_qq` varchar(50) DEFAULT NULL COMMENT '店铺客服qq',
  `shop_commission` decimal(10,2) DEFAULT NULL COMMENT '店铺佣金比例',
  `goods_warning_count` int(10) DEFAULT NULL COMMENT '货品预警数',
  `self_operated` int(10) DEFAULT NULL COMMENT '是否自营 1:是 0:否',
  `step` int(10) DEFAULT NULL COMMENT '申请开店进度：1,2.3.4',
  `ordin_receipt_status` int(1) DEFAULT '0' COMMENT '是否允许开具增值税普通发票 0：否，1：是',
  `elec_receipt_status` int(1) DEFAULT '0' COMMENT '是否允许开具电子普通发票 0：否，1：是',
  `tax_receipt_status` int(1) DEFAULT '0' COMMENT '是否允许开具增值税专用发票 0：否，1：是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺详细(es_shop_detail)';

-- ----------------------------
-- Records of es_shop_detail
-- ----------------------------
BEGIN;
INSERT INTO `es_shop_detail` VALUES (1, 1, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86,491', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/3E9C68F3BDFB42DF9B6CA1CCB5EF48C8.png', '', '', 1, 208, 'pc_1', 2, 'wap_1', 5.00, 4.25, 5.00, 5.00, 5.00, 0, 44, '123456', 0.50, 100, 1, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (2, 5, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/E72617113AB34D0EA79AB22344A79EE3.jpg', '', '', 1, 208, 'pc_1', 3, 'wap_2', 5.00, 5.00, 5.00, 5.00, 5.00, 0, 20, '123456', 0.50, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (3, 10, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0D372E1E01214C47A5F5D444B9DB2BDB.jpg', '', '', 1, 208, 'pc_1', 1384, 'wap_3', 5.00, 5.00, 5.00, 5.00, 5.00, 0, 20, '123456', 0.50, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (4, 15, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/BDF064F00E204068B9019E98464BD958.jpg', '', '', 1, 208, 'pc_1', 2, 'wap_1', 5.00, 5.00, 5.00, 5.00, 5.00, 0, 36, '123456', 0.50, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (5, 16, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/64161729403B4A699B6540A2BC6B9015.jpg', '', '', 1, 208, 'pc_1', 3, 'wap_2', 5.00, 5.00, 5.00, 5.00, 5.00, 0, 20, '123456', 0.50, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (6, 17, 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '测试地址', '易族智汇', '北京', '13333333333', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', '', '465413215', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '渊博大厦', 1427854939, 1427854939, 1534242083, '电商', '', '123456789', '', '', 'javashop', '1236154612359469', '北京银行', 1, 2816, 2862, 0, '北京', '密云区', '城区以外', '', '', 'ISO8895798454', '785875687', '', '1,4,35,38,56,79,85,86', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/1A866E7B465747BD882BE8C712068015.jpg', '', '', 1, 208, 'pc_1', 1384, 'wap_3', 5.00, 5.00, 5.00, 5.00, 5.00, 0, 20, '123456', 0.50, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES (7, 18, 1, 2800, 2848, 0, '北京', '海淀区', '三环以内', '', '北京海淀区三环以内', '易族智汇', '北京', '123456789', '123456@qq.com', 500, 500000000.00, 'kingapex', '13333333333', 'kingapex', '232326199911114579', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/CE4FD65E7B354C2AB803F617E73FD147.jpg', '465413215', 1, 2800, 2848, 0, '北京', '海淀区', '三环以内', '', '城区以外', 1508428800, 1506787200, 1919606400, '电商', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/23AE5D42D375460BB31A377E239BA5B4.jpg', '123456789', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0138AD6BBB0D4C858E34A38398534413.jpg', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/9D08D6B79CFC4B868D871867CC636EDB.jpg', '北京银行', '1236154612359469', 'javashop', 1, 2800, 2848, 0, '北京', '海淀区', '三环以内', '', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/46279032FE0B4E9FB45A67E6DBB84C6A.jpg', 'ISO8895798454', '785875687', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/F68D8A36A4104320B10B4F9B5B4227B8.jpg', '491', 1, 0, 0.00, 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/9AA9FBBCA1D74AEE964628AB2BF601A9.jpg', '', '', 0, 1382, 'pc_2', 2, 'wap_1', 4.00, 1.15, 5.00, 5.00, 5.00, 0, 71, '111222333', 0.00, 100, 0, 3, 1, 1, 1);
INSERT INTO `es_shop_detail` VALUES ('1470960016622432257', '1470960016404328449', '2', '78', '51978', '0', '上海', '黄浦区', '城区', '', '3223', '3423', '342', 'vI87qYMWW7WDBEpjcyon9g==', '2131321@qq.com', '111', '111.00', '111', 'mHMIFBFmLxMSkhATY6xa3g==', '213', 'Q26oB4W1YFIkYs6GH/KuDMp0Fk5lLxoe2ewCPj2DGPc=', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/normal/C69616D1493648BB8C3C5B50C5D028FF.jpeg', '11111', '2', '78', '51978', '0', '上海', '黄浦区', '城区', '', '111', '1639497600', '1639497600', '0', '21312321', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/normal/A5BEEFDABBBC4690833523FFB1759C3F.jpeg', '', '', '', '213123', 'oV2YT/QN0248EzEno+2rug==', '213213', '2', '78', '51978', '0', '上海', '黄浦区', '城区', '', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/normal/21A6D16C13374B35BD14ABD7D7853194.jpeg', '', '', '', '491,1,4,38,56,79,35,85,86', '1', '0', '0.00', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/shop/BDD8A44546FC49FE9973EEF5438B553C.png', '', '', null, '208', 'pc_1', '2', 'wap_1', '5.00', '0.00', '5.00', '5.00', '5.00', '0', '7', '', '5.00', '5', '0', '3', '0', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for es_shop_logi_rel
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_logi_rel`;
CREATE TABLE `es_shop_logi_rel` (
  `id` bigint(20) NOT NULL,
  `logi_id` bigint(20) DEFAULT NULL COMMENT '物流公司ID',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_shop_logi_rel` (`id`,`logi_id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺物流公司对照表(es_shop_logi_rel)';

-- ----------------------------
-- Records of es_shop_logi_rel
-- ----------------------------
BEGIN;
INSERT INTO `es_shop_logi_rel` VALUES (1, 1, 1);
INSERT INTO `es_shop_logi_rel` VALUES (2, 1, 18);
INSERT INTO `es_shop_logi_rel` VALUES (3, 3, 18);
INSERT INTO `es_shop_logi_rel` VALUES (4, 4, 18);
INSERT INTO `es_shop_logi_rel` VALUES (5, 5, 18);
INSERT INTO `es_shop_logi_rel` VALUES (6, 6, 1);
INSERT INTO `es_shop_logi_rel` VALUES (7, 8, 1);
INSERT INTO `es_shop_logi_rel` VALUES (8, 9, 18);
INSERT INTO `es_shop_logi_rel` VALUES (9, 10, 18);
INSERT INTO `es_shop_logi_rel` VALUES (10, 3, 15);
INSERT INTO `es_shop_logi_rel` VALUES (11, 4, 1);
INSERT INTO `es_shop_logi_rel` VALUES (12, 4, 10);
INSERT INTO `es_shop_logi_rel` VALUES (13, 4, 17);
INSERT INTO `es_shop_logi_rel` VALUES (14, 1, 16);
COMMIT;

-- ----------------------------
-- Table structure for es_shop_logistics_setting
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_logistics_setting`;
CREATE TABLE `es_shop_logistics_setting` (
  `id` bigint(20) NOT NULL,
  `shop_id` bigint(20) DEFAULT NULL,
  `logistics_id` bigint(20) DEFAULT NULL,
  `config` text,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_shop_logi_setting` (`id`,`shop_id`,`logistics_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of es_shop_logistics_setting
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_shop_menu
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_menu`;
CREATE TABLE `es_shop_menu` (
  `id` bigint(20) NOT NULL COMMENT '店铺菜单id',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '菜单父id',
  `title` varchar(100) DEFAULT NULL COMMENT '菜单标题',
  `identifier` varchar(100) DEFAULT NULL COMMENT '菜单唯一标识',
  `auth_regular` varchar(255) DEFAULT NULL COMMENT '权限表达式',
  `delete_flag` int(2) DEFAULT NULL COMMENT '删除标记',
  `path` varchar(100) DEFAULT NULL COMMENT '菜单级别标识',
  `grade` int(8) DEFAULT NULL COMMENT '菜单级别',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_shop_menu` (`id`,`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='菜单管理店铺(es_shop_menu)';

-- ----------------------------
-- Records of es_shop_menu
-- ----------------------------
BEGIN;
INSERT INTO `es_shop_menu` VALUES ('1', '0', '商品', 'goods', '/seller/goods.*', '0', ',1,', '1');
INSERT INTO `es_shop_menu` VALUES ('2', '0', '订单', 'order', '/seller.*', '0', ',2,', '1');
INSERT INTO `es_shop_menu` VALUES ('3', '0', '装修', 'shop', '/shop.*', '0', ',3,', '1');
INSERT INTO `es_shop_menu` VALUES ('4', '0', '促销', 'promotions', '/promotions*', '0', ',4,', '1');
INSERT INTO `es_shop_menu` VALUES ('5', '0', '统计', 'statistics', '/statistics*', '0', ',5,', '1');
INSERT INTO `es_shop_menu` VALUES ('6', '0', '售前售后', 'customer', '/customer*', '0', ',6,', '1');
INSERT INTO `es_shop_menu` VALUES ('7', '0', '设置', 'setting', '/setting*', '0', ',7,', '1');
INSERT INTO `es_shop_menu` VALUES ('8', '1', '商品列表', 'goodsList', '(/seller/goods.*)|(/seller/shops/cats.*)|(/seller/shops.*)|(/seller/promotion/exchange-cats.*)|(/seller/distribution/setting.*)', '0', ',1,8,', '2');
INSERT INTO `es_shop_menu` VALUES ('9', '1', '待审核商品', 'authGoodsList', '/seller/goods.*', '0', ',1,9', '2');
INSERT INTO `es_shop_menu` VALUES ('10', '1', '草稿箱', 'draftList', '(/seller/goods.*)|(/seller/shops/cats.*)|(/seller/shops.*)', '0', ',1,10,', '2');
INSERT INTO `es_shop_menu` VALUES ('11', '1', '分组管理', 'categoryManage', '/seller/shops/cats*', '0', ',1,11,', '2');
INSERT INTO `es_shop_menu` VALUES ('12', '1', '标签管理', 'tagManage', '/seller/goods*', '0', ',1,12,', '2');
INSERT INTO `es_shop_menu` VALUES ('13', '1', '回收站', 'recycleStation', '/seller/goods*', '0', ',1,13,', '2');
INSERT INTO `es_shop_menu` VALUES ('14', '1', '预警货品', 'understock', '/seller/goods*', '0', ',1,14,', '2');
INSERT INTO `es_shop_menu` VALUES ('15', '2', '订单列表', 'orderList', '(/seller/trade/orders.*)|(/seller/shops/logi-companies.*)|(/seller/express.*)', '0', ',2,15,', '2');
INSERT INTO `es_shop_menu` VALUES ('17', '2', '评价管理', 'commentsManage', '/seller/members/comments*', '0', ',2,17,', '2');
INSERT INTO `es_shop_menu` VALUES ('18', '2', '结算管理', 'settlementManage', '/seller/order/bills*', '0', ',2,18,', '2');
INSERT INTO `es_shop_menu` VALUES ('19', '2', '开票历史', 'receiptHistory', '/seller/members/receipts*', '0', ',2,19,', '2');
INSERT INTO `es_shop_menu` VALUES ('20', '3', 'PC端微页面', 'pcPages', '/seller*', '0', ',2,20,', '2');
INSERT INTO `es_shop_menu` VALUES ('21', '3', '移动端微页面', 'mobilePages', '/seller/shops*', '0', ',3,21,', '2');
INSERT INTO `es_shop_menu` VALUES ('23', '3', 'PC端店铺导航', 'shopNav', '/seller/shops/navigations.*', '0', ',3,23,', '2');
INSERT INTO `es_shop_menu` VALUES ('24', '4', '满减满赠', 'fullCut', '(/seller/promotion/full-discounts.*)|(/seller/promotion/coupons.*)|(/seller/promotion/full-discount-gifts/all)', '0', ',4,24,', '2');
INSERT INTO `es_shop_menu` VALUES ('25', '4', '优惠券', 'discountManager', '/seller/promotion/coupons.*', '0', ',4,25,', '2');
INSERT INTO `es_shop_menu` VALUES ('26', '4', '单品立减', 'singleCut', '/seller/promotion/minus.*', '0', ',4,26,', '2');
INSERT INTO `es_shop_menu` VALUES ('27', '4', '第二件半价', 'secondHalfPrice', '/seller/promotion/half-prices.*', '0', ',4,27,', '2');
INSERT INTO `es_shop_menu` VALUES ('28', '4', '赠品', 'giftManager', '/seller/promotion/full-discount-gifts.*', '0', ',4,28,', '2');
INSERT INTO `es_shop_menu` VALUES ('29', '4', '团购', 'groupBuyManager', '/seller/promotion/group-buy-goods.*', '0', ',4,29,', '2');
INSERT INTO `es_shop_menu` VALUES ('30', '4', '限时抢购', 'timeLimit', '/seller/promotion/seckill-applys.*', '0', ',4,30,', '2');
INSERT INTO `es_shop_menu` VALUES ('31', '5', '店铺概况', 'generalityOverview', '/seller/statistics/shop_profile.*', '0', ',5,31,', '2');
INSERT INTO `es_shop_menu` VALUES ('32', '5', '商品分析', 'goodsAnalysis', '/seller/statistics.*', '0', ',5,32,', '2');
INSERT INTO `es_shop_menu` VALUES ('33', '5', '运营报告', 'operateReport', '/operateReport.*', '0', ',5,33,', '2');
INSERT INTO `es_shop_menu` VALUES ('34', '5', '流量统计', 'trafficStatistics', '/seller/statistics/page_view/shop.*', '0', ',5,34,', '2');
INSERT INTO `es_shop_menu` VALUES ('35', '5', '收藏统计', 'collectStatistics', 'seller/statistics/collect.*', '0', ',5,35,', '2');
INSERT INTO `es_shop_menu` VALUES ('36', '32', '商品详情', 'goodsDetailsAnalysis', '(/seller/statistics/goods/goods_detail.*)|(/seller/goods/category/seller/children.*)', '0', ',5,32,36,', '3');
INSERT INTO `es_shop_menu` VALUES ('37', '32', '价格销量', 'goodsPriceSales', '(/seller/statistics/goods/price_sales.*)|(/seller/goods/category/seller/children.*)', '0', ',5,32,37,', '3');
INSERT INTO `es_shop_menu` VALUES ('38', '32', '热卖商品', 'hotSellingGoods', '(/seller/statistics/goods/order_price.*)|(/seller/statistics/goods/order_price_page.*)', '0', ',5,32,38,', '3');
INSERT INTO `es_shop_menu` VALUES ('39', '33', '区域分析', 'regionalAnalysis', '/seller/statistics/reports/regions.*', '0', ',5,33,39,', '3');
INSERT INTO `es_shop_menu` VALUES ('40', '33', '销售统计', 'salesStatistics', '/seller/statistics/reports.*', '0', ',5,33,40,', '3');
INSERT INTO `es_shop_menu` VALUES ('41', '33', '购买分析', 'buyAnalysis', '(/seller/statistics/reports/purchase/period.*)|(/seller/statistics/reports/purchase/ranges.*)', '0', ',5,33,41,', '3');
INSERT INTO `es_shop_menu` VALUES ('42', '6', '咨询', 'consultation', '/seller/members/asks.*', '0', ',6,42,', '2');
INSERT INTO `es_shop_menu` VALUES ('43', '6', '消息', 'message', '/seller/shops/shop-notice-logs.*', '0', ',6,43,', '2');
INSERT INTO `es_shop_menu` VALUES ('44', '7', '店铺设置', 'shopSettings', '/seller/shops.*', '0', ',7,44,', '2');
INSERT INTO `es_shop_menu` VALUES ('45', '7', '货品预警', 'goodsWarning', '/seller/shops.*', '0', ',7,45,', '2');
INSERT INTO `es_shop_menu` VALUES ('46', '7', '发票设置', 'invoiceSettings', '/seller/shops.*', '0', ',7,46', '2');
INSERT INTO `es_shop_menu` VALUES ('47', '7', '物流管理', 'logisticsManage', '(/seller/shops/ship-templates.*)|(/regions/depth.*)|(/seller/shops/logi-companies.*)', '0', ',7,47,', '2');
INSERT INTO `es_shop_menu` VALUES ('48', '7', '权限', 'shopAuth', '/shopAuth.*', '0', ',7,48,', '2');
INSERT INTO `es_shop_menu` VALUES ('49', '48', '店员', 'shopAssistant', '(/seller/shops/clerks.*)|(/seller/shops/roles.*)', '0', ',7,48,49,', '3');
INSERT INTO `es_shop_menu` VALUES ('50', '48', '角色', 'roleManage', '/seller/shops/roles.*', '0', ',7,48,50,', '3');
INSERT INTO `es_shop_menu` VALUES ('51', '4', '拼团', 'assembleManager', '/seller/promotion/pintuan.*', '0', ',4,51,', '2');
INSERT INTO `es_shop_menu` VALUES ('52', '6', '交易投诉', 'complaintList', '/seller/trade/order-complains.*', '0', ',6,52,', '2');
INSERT INTO `es_shop_menu` VALUES ('54', '6', '售后', 'afterSale', '/seller/after-sales.*', '0', ',6,54', '2');
INSERT INTO `es_shop_menu` VALUES ('55', '54', '售后服务单', 'serviceList', '/seller/after-sales.*', '0', ',6,54,55', '3');
INSERT INTO `es_shop_menu` VALUES ('56', '54', '退款单', 'refundList', '/seller/after-sales/refund.*', '0', ',6,54,56', '3');
INSERT INTO `es_shop_menu` VALUES ('58', '0', '在线客服', 'chat', '(/seller/trade/orders.*)|(/seller/goods.*)', '0', ',58,', '1');
COMMIT;

-- ----------------------------
-- Table structure for es_shop_notice_log
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_notice_log`;
CREATE TABLE `es_shop_notice_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺ID',
  `notice_content` varchar(255) DEFAULT NULL COMMENT '站内信内容',
  `send_time` bigint(50) DEFAULT NULL COMMENT '发送时间',
  `is_delete` int(10) DEFAULT NULL COMMENT '是否删除 ：1 删除   0  未删除',
  `is_read` int(10) DEFAULT NULL COMMENT '是否已读 ：1已读   0 未读',
  `type` varchar(10) DEFAULT NULL COMMENT '消息类型',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_shop_notice_log` (`id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺站内消息(es_shop_notice_log)';

-- ----------------------------
-- Records of es_shop_notice_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for es_shop_role
-- ----------------------------
DROP TABLE IF EXISTS `es_shop_role`;
CREATE TABLE `es_shop_role` (
  `role_id` bigint(20) NOT NULL COMMENT '角色主键',
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `auth_ids` longtext COMMENT '角色 ',
  `role_describe` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  PRIMARY KEY (`role_id`) USING BTREE,
  KEY `index_shop_role` (`role_id`,`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='店铺角色(es_shop_role)';

-- ----------------------------
-- Records of es_shop_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime NOT NULL COMMENT 'create datetime',
  `log_modified` datetime NOT NULL COMMENT 'modify datetime',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4688 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='AT transaction mode undo table';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
